Thread: ALTER DOMAIN DROP CONSTRAINT doesn't catch errors

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.

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