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