Re: Chatter on DROP SOMETHING IF EXISTS

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Chatter on DROP SOMETHING IF EXISTS
Дата
Msg-id 20070207192320.GA23486@wolff.to
обсуждение исходный текст
Ответ на Re: Chatter on DROP SOMETHING IF EXISTS  (David Fetter <david@fetter.org>)
Список pgsql-hackers
On Wed, Feb 07, 2007 at 10:53:34 -0800, David Fetter <david@fetter.org> wrote:
> On Wed, Feb 07, 2007 at 02:13:48PM +0100, Peter Eisentraut wrote:
> > What is the practical purpose of the notices emitted by DROP
> > SOMETHING IF EXISTS when the object in fact does not exist?
> 
> DROP ... IF EXISTS is guaranteed not to throw an error.  This lets
> people write idempotent scripts which run in a transaction :)

I don't think that's what his question was. I think it was more along the
lines of why don't we get rid of the notices that are just cluttering things
up.


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Ooops ... seems we need a re-release pronto
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Status of autovacuum and the sporadic stats failures ?