Thread: DROP CONSTRAINT IF EXISTS

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.

<william.a.dean@gdc4s.com> writes:
> 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.

Apparently you're reading 9.0 documentation and using a pre-9.0 server.
Please see the manual appropriate to your PG version.

            regards, tom lane