Re: Auto-timestamp generator (attached)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Auto-timestamp generator (attached)
Date: 2001-02-08 23:42:59
Message-ID: 13607.981675779@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> playpen=# select lastchg_addto('foo','c');
> ERROR: plpgsql: cache lookup from pg_proc failed

Somewhere you've got a stored plan --- probably a view or rule or
trigger, if it persists across backend runs --- that refers to a plpgsql
function that no longer exists (at least not under the same OID). You
need to drop and recreate that view or whatever. Unfortunately you
haven't shown us enough info to guess which one...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2001-02-09 00:18:15 Re: Auto-timestamp generator (attached)
Previous Message Joseph Shraibman 2001-02-08 23:24:27 Re: Auto-timestamp generator (attached)