View Single Post

   
  #3 (permalink)  
Old 04-19-2008, 06:27 AM
Andrew Dunstan
 
Posts: n/a
Default Re: create language ... if not exists



Heikki Linnakangas wrote:
> Andreas 'ads' Scherbaum wrote:
>> The attached patch for HEAD extends the CREATE LANGUAGE statement by an
>> IF NOT EXISTS option which in effect changes the raised error into a
>> notice.
>>
>> Before i continue working on this patch i would like to know if this
>> extension has a chance to go into PG and what other changes i should
>> apply (beside the missing documentation).

>
> The way we've solved this problem for other CREATE commands is to add
> "OR REPLACE" option, instead of "IF NOT EXISTS". We should do the same
> here.
>
>


My recollection is that we only do that where we need to for reasons of
dependency. Not sure that applies here.

cheers

andrew

--
Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches

Reply With Quote