Re: Rule recompilation

Tom Lane wrote:
> Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
>
> > In the PL/pgSQL case it *might* be possible. But is it worth
> > it?
>
> Yes. If we're not going to do it right, I think we needn't bother to do
> it at all. "Restart your backend" is just as good an answer, probably
> better, than "issue a RECOMPILE against everything affected by whatever
> you changed". If the system can't keep track of that, how likely is it
> that the user can?

Stop!

We're talking about two different things here.

Recompilation (or better fixing Oid references in system
catalog entries) is required to correct a system catalog that
got inconsistent due to dropping and recreating a particular
object.

Regeneration of runtime things like saved SPI plans might be
related to that, but it's not exactly the same. That surely
is corrected by restarting the backend. But you cannot
correct a broken view with a backend restart, can you?

And pardon, but PL/Tcl can save SPI plans. At least it had
that capability when I wrote the language handler, so if it
cannot any more WHO DID THAT?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com