Re: Rule recompilation

Mikheev, Vadim wrote:
> > > In good world rules (PL functions etc) should be automatically
> > > marked as dirty (ie recompilation required) whenever referenced
> > > objects are changed.
> >
> > Yepp, and it'd be possible for rules (just not right now).
> > But we're not in a really good world, so it'll not be
> > possible for PL's.
>
> Why is it possible in Oracle' world? -:)

Because of there limited features?

Think about a language like PL/Tcl. At the time you call a
script for execution, you cannot even be sure that the Tcl
bytecode compiler parsed anything, so how will you ever know
the complete set of objects referenced from this function?

And PL/pgSQL? We don't prepare all the statements into SPI
plans at compile time. We wait until the separate branches
are needed, so how do you know offhand here?

In the PL/pgSQL case it *might* be possible. But is it worth
it?

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