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

> > 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
>
>TIP 5: Have you checked our extensive FAQ?
>http://www.postgresql.org/users-lounge/docs/faq.html

Hello,

Does CREATE OR REPLACE FUNCTION preserve function OID?
What it the difference with CREATE OR ALTER FUNCTION?

We would like to implement pseudo-editing of functions in pgAdmin II.
Is there any solution which preserves function OID?

Best regards,
Jean-Michel POURE