Re: CREATE OR REPLACE FUNCTION - Mailing list pgsql-patches

From Tom Lane
Subject Re: CREATE OR REPLACE FUNCTION
Date
Msg-id 14284.1001173037@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE OR REPLACE FUNCTION  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: CREATE OR REPLACE FUNCTION  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> ... I see no reason to add this capability
> if it requires adding a new toplevel keyword.

That kind of annoys me too, but since the keyword can be made a TokenId,
it won't create any conflicts.  I think the argument of Oracle
compatibility is probably a sufficient reason to do it with this syntax.

> You could hack ALTER FUNCTION to create automatically if it
> doesn't exist,

That's considerably uglier than this alternative, wouldn't you say?
We have no other ALTER commands that work that way.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: CREATE OR REPLACE FUNCTION
Next
From: Tom Lane
Date:
Subject: Re: CREATE OR REPLACE FUNCTION