Re: DROP CONSTRAINT IF EXISTS - Mailing list pgsql-bugs

From Tom Lane
Subject Re: DROP CONSTRAINT IF EXISTS
Date
Msg-id 25298.1281743639@sss.pgh.pa.us
Whole thread Raw
In response to DROP CONSTRAINT IF EXISTS  (<william.a.dean@gdc4s.com>)
List pgsql-bugs
<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

pgsql-bugs by date:

Previous
From:
Date:
Subject: DROP CONSTRAINT IF EXISTS
Next
From: Itagaki Takahiro
Date:
Subject: Re: BUG #5608: array_agg() consumes too much memory