Re: Truncate if exists - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Truncate if exists
Date
Msg-id 5075A8E2.7010103@agliodbs.com
Whole thread Raw
In response to Re: Truncate if exists  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Truncate if exists  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 10/9/12 1:35 PM, Peter Eisentraut wrote:
> On 10/9/12 5:09 AM, Simon Riggs wrote:
>> Anyone want to check for any other missing IF EXISTS capability in other DDL?
> 
> TRUNCATE is not really DDL.  If we allow TRUNCATE IF EXISTS, what is
> stopping someone from requesting DELETE IF EXISTS or INSERT IF EXISTS next?

That's a very good point.  I tend to think of all utility commands as
DDL, which of course they're not.


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Is there a good reason why PL languages do not support cstring type arguments and return values ?
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: PQping command line tool