Skip site navigation (1) Skip section navigation (2)

DROP CONSTRAINT IF EXISTS

From: <william(dot)a(dot)dean(at)gdc4s(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: DROP CONSTRAINT IF EXISTS
Date: 2010-08-13 19:26:49
Message-ID: 3DFFB0670A395946974CE996C72073241C496AB2@NDHMC4SXCH.gdc4s.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The sql statement  'ALTER TABLE <table name> DROP CONSTRAINT IF EXISTS
<constraint-name>' returns with a syntax error on exists.  The
documentation states that the IF EXISTS clause is allowed in DROP
CONSTRAINT statements.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-08-13 23:53:59
Subject: Re: DROP CONSTRAINT IF EXISTS
Previous:From: Tom LaneDate: 2010-08-13 19:01:54
Subject: Re: Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group