Horton
Menu

Re: Chatter on DROP SOMETHING IF EXISTS

Bruno Wolff III <bruno@wolff.to>

View thread
From: Bruno Wolff III <bruno@wolff.to>
To: David Fetter <david@fetter.org>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2007-02-07T19:23:20Z
Lists: 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.