ALTER DOMAIN DROP CONSTRAINT doesn't catch errors

Started by Peter Eisentrautabout 14 years ago2 messages
#1Peter Eisentraut
peter_e@gmx.net

Is there a secret reason why

ALTER DOMAIN foo DROP CONSTRAINT nonexistent;

doesn't report any error?

If not, I think we should add one and also add the usual IF EXISTS
option.

#2Robert Haas
robertmhaas@gmail.com
In reply to: Peter Eisentraut (#1)
Re: ALTER DOMAIN DROP CONSTRAINT doesn't catch errors

On Thu, Dec 29, 2011 at 4:02 PM, Peter Eisentraut <peter_e@gmx.net> wrote:

Is there a secret reason why

ALTER DOMAIN foo DROP CONSTRAINT nonexistent;

doesn't report any error?

If not, I think we should add one and also add the usual IF EXISTS
option.

+1.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company