On 23 Feb 2002 at 14:50, Tom Lane wrote:

> "Dan Langille" <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to