Re: [HACKERS] fmgr_info: function 20071: cache lookup failed

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
Date: 2002-02-21 20:23:39
Message-ID: 200202212023.g1LKNdFP005038@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-21 20:54:50 Re: [HACKERS] fmgr_info: function 20071: cache lookup failed
Previous Message Denis Chavez 2002-02-21 20:08:45 About groups in postgres

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2002-02-21 20:30:20 Re: PostgreSQL GUI?
Previous Message Jean-Michel POURE 2002-02-21 20:16:27 Re: Postgresql/linux speed + reliability

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2002-02-21 20:25:44 Re: DateStyle bug
Previous Message Marc G. Fournier 2002-02-21 20:11:26 Re: PostgreSQL 8.0 ??