Horton
Menu

Re: Chatter on DROP SOMETHING IF EXISTS

David Fetter <david@fetter.org>

View thread
From: David Fetter <david@fetter.org>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Date: 2007-02-07T18:53:34Z
Lists: pgsql-hackers 
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 :)

Cheers,
D
-- 
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!