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

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Date: 2001-10-04 13:49:50
Message-ID: 4.2.0.58.20011004154022.02170400@pop.freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-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(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

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-04 14:00:32 Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Previous Message Jean-Michel POURE 2001-10-04 13:39:56 Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-04 14:00:32 Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Previous Message Tom Lane 2001-10-04 13:39:34 Re: Feature suggestion: Postgresql binding to one