Re: create language ... if not exists

Поиск
Список
Период
Сортировка
От Andreas 'ads' Scherbaum
Тема Re: create language ... if not exists
Дата
Msg-id 20080330124917.7039afe0@iridium.wars-nicht.de
обсуждение исходный текст
Ответ на Re: create language ... if not exists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Hello all,

sorry, was off yesterday and i'm just reading all your answers.

On Sat, 29 Mar 2008 22:35:21 -0400 Tom Lane wrote:

> I wrote:
> > ... However, I seem to recall
> > that in the discussions leading up to implementing DROP IF EXISTS,
> > we considered and specifically rejected CREATE IF NOT EXISTS.  Don't
> > have time right now to troll the archives for the reasoning.
>
> [ back from dinner party... ]  Here's the thread I was remembering:
> http://archives.postgresql.org/pgsql-hackers/2005-10/msg00632.php
>
> The key argument seems to be that it's quite unclear what the state
> following CREATE IF NOT EXISTS (CINE) should be, if the object does
> exist but not with the same properties specified in the CINE command.
> CREATE OR REPLACE resolves that by making it clear that it's gonna be
> what the command says.

Tom: this answers my other question: if someone executes a REPLACE
LANGUAGE and as example is using another handler, the new handler
should replace the old one. Correct?

So i will change my small patch and reimplement this extension with
CREATE OR REPLACE.


Thanks all for your useful answers.

--
                Andreas 'ads' Scherbaum
German PostgreSQL User Group

В списке pgsql-patches по дате отправления:

Предыдущее
От: Andreas 'ads' Scherbaum
Дата:
Сообщение: Re: create language ... if not exists
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reference by output in : \d