From: | "Dan Langille" <dan(at)langille(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Sean Chittenden <sean(at)chittenden(dot)org>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: 7.1->7.2 data import timestamp problems |
Date: | 2002-02-23 20:14:53 |
Message-ID: | 200202232014.g1NKEuk43959@lists.unixathome.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 23 Feb 2002 at 14:50, Tom Lane wrote:
> "Dan Langille" <dan(at)langille(dot)org> writes:
> > now I'm getting: ERROR: SearchSysCache: Bad cache id 27
>
> I believe we've seen this from trying to load a 7.1 plpgsql.so
> into 7.2.
Tom! Well done. Thank you. That was the problem.[1] After correcting
that, I started to get:
ERROR: fmgr_info: function 944463: cache lookup failed
I tried to the just reload the stored procedures, but had to reload the
entire db to fix that one.
Much appreciated.
[1] - the change I made: this
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'/usr/local/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
became
CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'/usr/local/lib/postgresql/plpgsql.so', 'plpgsql_call_handler'
LANGUAGE 'C';
which is the default location under the latest FreeBSD port.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Chittenden | 2002-02-23 20:18:46 | Re: 7.1->7.2 data import timestamp problems |
Previous Message | Bruce Momjian | 2002-02-23 19:53:36 | Re: 7.1->7.2 data import timestamp problems |