Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

Hi,

Think this might be interesting.
If CREATE OR REPLACE FUNCTION comes up, views and triggers will not break
anymore.

Cheers,
Jean-Michel POURE

****************************************************************************
****************************************

> Did we come to any conclusion about whether to accept Gavin Sherry's
> CREATE OR REPLACE FUNCTION patch?
> http://fts.postgresql.org/db/mw/msg.html?mid=1035792
>
> AFAIR, the score was that I liked it, Bruce didn't, and no one else
> had expressed an opinion.

I withdraw my objection. When I read it, I thought we were going to
have CREATE FUNCTION and REPLACE FUNCTION. I later realized it is
literally CREATE OR REPLACE FUNCTION. Looks strange, but there is no
standard way to do this and we usually take the Oracle syntax when the
standard doesn't specify it.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html