Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2

Поиск
Список
Период
Сортировка
От Jean-Paul ARGUDO
Тема Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2
Дата
Msg-id 20020227173601.A18831@singer.ird.idealx.com
обсуждение исходный текст
Ответ на function tree_level(varchar) (from OpenACS) no longer work under 7.2  (Jean-Paul ARGUDO <jean-paul.argudo@idealx.com>)
Список pgsql-bugs
Дерево обсуждения 
> > ERROR:  SearchSysCache: Bad cache id 27
> This is not a bug, it is a broken installation.  You are trying to
> invoke a 7.1 plpgsql in a 7.2 backend.

Right analysis Tom!

createlang with old plpgsql.so ...

had to drop functions / triggers using old plpgsql.so (thanks to a select on
pg_proc)

drop the language

create the language

rebuild functions and triggers: all ok now..

Thanks Tom.

--
Jean-Paul ARGUDO

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jean-Paul ARGUDO
Дата:
Сообщение: function tree_level(varchar) (from OpenACS) no longer work under 7.2
Следующее
От: Reinhard Max
Дата:
Сообщение: performance problems on updates on large tables with indexes