Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why? - Mailing list pgsql-novice

From Tom Lane
Subject Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?
Date
Msg-id 5173.979852518@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: plpgsql: cache lookup from pg_proc failed -- Why?  ("zivit" <zivit@congruency.co.il>)
List pgsql-novice
Tree view 
"zivit" <zivit@congruency.co.il> writes:
> We have the following problem on executing trigger: ERROR: plpgsql: cache
> lookup from pg_proc failed.

Did you perhaps drop and recreate the function after creating the
trigger?  If so, you have to drop and recreate the trigger as well.
This is annoying, but no one's gotten around to fixing it yet ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Matt Friedman"
Date:
Subject: creating a constraint on the same table
Next
From: "Stefan Waidele jun."
Date:
Subject: Re: Interval output format