Re: Add OR REPLACE clauses to non-FUNCTION object creation

Jean-Michel POURE wrote:
> Le Mercredi 23 Janvier 2002 15:16, Gavin Sherry a écrit :
> > > There is a strong need for :
> > > - CREATE OR REPLACE VIEW,
> > > - CREATE OR REPLACE TRIGGER.
> > I intend to do this.
> > Gavin
>
> Gavin, you suddenly became the community hero. Can you hear the screems of
> your fans? There is a crowd waiting for you. Where can I get a t-shirt with
> your name on it?
   But  please  don't forget that simply overwriting an existing   pg_proc tuple will not cause a persistent database
connection  to use the new version. PL/Tcl and PL/pgSQL for example cache   the precompiled procedure based on  it's
oid. So  at  least   think of a version count that get's bumped and checked in the   PL handlers.
 


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