Lists: | pgsql-hackers |
---|
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | ALTER DOMAIN DROP CONSTRAINT doesn't catch errors |
Date: | 2011-12-29 21:02:34 |
Message-ID: | 1325192554.3702.2.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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.
From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: ALTER DOMAIN DROP CONSTRAINT doesn't catch errors |
Date: | 2012-01-05 13:15:22 |
Message-ID: | CA+TgmoZ9uCaKadOz5SYrWAjsie_81WcGrqZDAt7XN4hJ0W=Lsg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Thu, Dec 29, 2011 at 4:02 PM, Peter Eisentraut <peter_e(at)gmx(dot)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