Horton
Menu

Re: Truncate if exists

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Sébastien Lardière <slardiere@hi-media.com>, pgsql-hackers@postgresql.org, cedric@2ndquadrant.fr
Date: 2012-10-09T20:35:50Z
Lists: pgsql-hackers 
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?