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

From: Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com>, pgsql-bugs(at)postgresql(dot)org, sdinot(at)idealx(dot)com, dbarth(at)idealx(dot)com
Subject: Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2
Date: 2002-02-27 16:36:01
Message-ID: 20020227173601.A18831@singer.ird.idealx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-02-27 21:41:55 Re: performance problems on updates on large tables with indexes
Previous Message Reinhard Max 2002-02-27 16:29:17 performance problems on updates on large tables with indexes