Re: create language ... if not exists - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: create language ... if not exists
Date
Msg-id 47EE3F6C.1080908@dunslane.net
Whole thread Raw
In response to Re: create language ... if not exists  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: create language ... if not exists  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches

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

pgsql-patches by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: [HACKERS] Avahi support for Postgresql
Next
From: Tom Lane
Date:
Subject: Re: create language ... if not exists