Dear all,

After migration to PostgreSQL 7.2, modifying a function with CREATE OR 
REPLACE foo, and running the function, backend returns :

fmgr_info: function 20071: cache lookup failed.
Any idea?

Best regards,
Jean-Michel POURE

Thu, 21 Feb 2002 19:42:12 +0100
Jean-Michel POURE <jm.poure@freesurf.fr>
fmgr_info: function 20071: cache lookup failed


On Thu, 21 Feb 2002, Jean-Michel POURE wrote:

> Dear all,
>
> After migration to PostgreSQL 7.2, modifying a function with CREATE OR
> REPLACE foo, and running the function, backend returns :
>
> fmgr_info: function 20071: cache lookup failed.
> Any idea?

Is 20071 the oid of the function in question? Can you give a standalone
example that gives the error?


Thu, 21 Feb 2002 12:05:59 -0800 (PST)
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
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

Thu, 21 Feb 2002 21:23:39 +0100
Jean-Michel POURE <jm.poure@freesurf.fr>
Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
On Thu, 21 Feb 2002, Jean-Michel POURE wrote:

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

Wanted to be sure it wasn't some other function that might be being
referenced therein.

> > 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.

Hmm, I just did a simple test of a before insert/update trigger and
updating with create or replace from psql and didn't have a problem.  Can
you give the tables/functions involved?



Thu, 21 Feb 2002 12:54:50 -0800 (PST)
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
> 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.

Dear all,

Please disregard my previous message. In pgAdmin2, I dropped the old tables 
and functions pgadmin_*. But going too fast, I also dropped 
plpgsql_call_handler by error. What a fool ...

Thu, 21 Feb 2002 22:01:01 +0100
Jean-Michel POURE <jm.poure@freesurf.fr>
Re: [HACKERS] fmgr_info: function 20071: cache lookup failed