Re: Chatter on DROP SOMETHING IF EXISTS - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Chatter on DROP SOMETHING IF EXISTS
Date
Msg-id 20070207192320.GA23486@wolff.to
Whole thread Raw
In response to Re: Chatter on DROP SOMETHING IF EXISTS  (David Fetter <david@fetter.org>)
List 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 by date:

Previous
From: Neil Conway
Date:
Subject: Re: Ooops ... seems we need a re-release pronto
Next
From: Tom Lane
Date:
Subject: Re: Status of autovacuum and the sporadic stats failures ?