Re: [BUGS] DROP CONSTRAINT IF EXISTS

2010-08-13 Thread Tom Lane
writes: > The sql statement 'ALTER TABLE DROP CONSTRAINT IF EXISTS > ' 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

[BUGS] DROP CONSTRAINT IF EXISTS

2010-08-13 Thread william.a.dean
The sql statement 'ALTER TABLE DROP CONSTRAINT IF EXISTS ' returns with a syntax error on exists. The documentation states that the IF EXISTS clause is allowed in DROP CONSTRAINT statements.