Re: Bug #646: Problems inserting new records - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #646: Problems inserting new records
Date
Msg-id 2245.1019753487@sss.pgh.pa.us
Whole thread Raw
In response to Bug #646: Problems inserting new records  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> SearchSys Cache: Bad cache id 27

IIRC, this is a common symptom of a plpgsql.so library that's out of
sync with your backend (ie, 7.2 backend, 7.1 plpgsql.so).  I suspect
the failure is coming from a plpgsql function or trigger and has
nothing to do with the rules you showed us.

Check whether the declaration of plpgsql_call_handler points at the
right .so file.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #647: test
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #648: connection JDBC-POSTGRESQL