Re: Auto-timestamp generator (attached)

Tom Lane wrote:
>
> 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

It is persisting accross backend restarts, and on a newly created
database too.  There are no views, rules, or triggers on this database.

If this is involving rules, could this be related to the patched version
of command.c that I have (the patch was to fix an error when trying to
add foreign keys, see:
http://postgresql.readysetnet.com/mhonarc/pgsql-sql/2000-12/msg00057.html
)?

The patched command.c is at:
http://www.selectacast.net/~jks/postgres/command.c


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com