Re: Auto-timestamp generator (attached) - Mailing list pgsql-general

From Tom Lane
Subject Re: Auto-timestamp generator (attached)
Date
Msg-id 13607.981675779@sss.pgh.pa.us
Whole thread Raw
In response to Re: Auto-timestamp generator (attached)  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman <jks@selectacast.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

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: Auto-timestamp generator (attached)
Next
From: Joseph Shraibman
Date:
Subject: Re: Auto-timestamp generator (attached)