Postgres Pro
Downloads
Home   >   mailing lists

Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2 - Mailing list pgsql-bugs

From Jean-Paul ARGUDO
Subject Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2
Date
Msg-id 20020227173601.A18831@singer.ird.idealx.com
Whole thread Raw
In response to function tree_level(varchar) (from OpenACS) no longer work under 7.2  (Jean-Paul ARGUDO <jean-paul.argudo@idealx.com>)
List pgsql-bugs
Tree view 
> > 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 by date:

Previous
From: Jean-Paul ARGUDO
Date:
Subject: function tree_level(varchar) (from OpenACS) no longer work under 7.2
Next
From: Reinhard Max
Date:
Subject: performance problems on updates on large tables with indexes