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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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