Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group