> > 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 >[EMAIL PROTECTED] | (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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
