Re: fmgr_info: function 20071: cache lookup failed - Mailing list pgsql-hackers

From Jean-Michel POURE
Subject Re: fmgr_info: function 20071: cache lookup failed
Date
Msg-id 200202212023.g1LKNdFP005038@www1.translationforge
Whole thread Raw
In response to Re: fmgr_info: function 20071: cache lookup failed  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: fmgr_info: function 20071: cache lookup failed
Re: fmgr_info: function 20071: cache lookup failed
List pgsql-hackers
Dear Stephan ,

> Is 20071 the oid of the function in question?
Yes, as from the error message. It is quite surprising.

> Can you give a standalone example that gives the error?
After updating a PLpgSQL function of a trigger on table foo with CREATE OR
REPLACE using latest version of pgAdmin2.

If I run "UPDATE TABLE foo SET foo_timestamp = 'now' WHERE .... sql clause"
will return an error. It seems to be a migration problem.

Cheers,
Jean-Michel

pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: PostgreSQL 8.0 ??
Next
From: Thomas Lockhart
Date:
Subject: Re: DateStyle bug