Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: zivit(at)congruency(dot)co(dot)il
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?
Date: 2001-01-18 21:15:18
Message-ID: 5173.979852518@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"zivit" <zivit(at)congruency(dot)co(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stefan Waidele jun. 2001-01-18 21:40:22 Re: Interval output format
Previous Message Matt Friedman 2001-01-18 20:52:16 creating a constraint on the same table