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: Whole Thread | Raw Message | 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