Re: drop if exists

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: drop if exists
Date: 2005-10-15 16:30:21
Message-ID: AB7A45D0851DC49E56AE3946@[192.168.100.105]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On Samstag, Oktober 15, 2005 17:20:06 +0200 Martijn van Oosterhout
<kleptog(at)svana(dot)org> wrote:

> Although the
> effect is obvious for functions, it seems to me that it would be cool
> to make a CREATE OR REPLACE TABLE that simply does nothing if the table
> already exists with the right format.

Hmm i don't think this is the right semantic, because CREATE OR REPLACE for
other objects does indeed something, simply ignoring an existing object
isn't what i would expect.

--
Thanks

Bernd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Anuj Tripathi 2005-10-15 16:49:44 Plan structure
Previous Message Tom Lane 2005-10-15 16:04:50 Re: drop if exists