Re: plpgsql - cont'd

"Mitch Vincent" <mitch@venux.net> writes:
> Hmm, this is the third time this has happened.. I am using 7.1 Bert 3, so I
> expected some things like this... When deleting and adding functions back,
> when I run them I get :

> ERROR:  plpgsql: cache lookup for proc 49237 failed

> -- What's happening there and is there anyway to fix this without having to
> dump/restore (which is what I've had to do thus far.. ) ?

dump/restore is the hard way.  If you delete and recreate a function,
the new incarnation has a new OID, so anything that referred to the old
OID is now broken, and has to be deleted/recreated itself.  Triggers
are one such reference.  Cached query plans are another, although I
don't think that's the issue here.  How are you invoking the functions,
anyway?

            regards, tom lane