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
thisfunction?
 
   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@Yahoo.com #



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