Re: [HACKERS] What about CREATE OR REPLACE FUNCTION? - Mailing list pgadmin-hackers

From Jean-Michel POURE
Subject Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Date
Msg-id 4.2.0.58.20011004154022.02170400@pop.freesurf.fr
Whole thread Raw
Responses Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?  (Gavin Sherry <swm@linuxworld.com.au>)
Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgadmin-hackers
> > 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@candle.pha.pa.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

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Next
From: Gavin Sherry
Date:
Subject: Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?