Postgres Pro
Downloads
Home   >   mailing lists

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

From David Fetter
Subject Re: Chatter on DROP SOMETHING IF EXISTS
Date
Msg-id 20070207185334.GA8836@fetter.org
Whole thread Raw
In response to Chatter on DROP SOMETHING IF EXISTS  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Chatter on DROP SOMETHING IF EXISTS  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-hackers
Tree view 
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!

pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Proposal: TABLE functions
Next
From: Richard Troy
Date:
Subject: Re: Proposal: Commit timestamp