Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Making a unique constraint deferrable? - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Making a unique constraint deferrable?
Date
Msg-id CAKFQuwbpcWp4xFU+x7y5_EX+p6uyBqBaNKpYhUd3201c-aMPzA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Making a unique constraint deferrable?  (Ivan Voras <ivoras@gmail.com>)
Responses Re: [GENERAL] Making a unique constraint deferrable?  (Ivan Voras <ivoras@gmail.com>)
List pgsql-general
Tree view
On Tue, Feb 28, 2017 at 9:50 AM, Ivan Voras <ivoras@gmail.com> wrote:

ivoras=# alter table foo alter constraint "foo_a_b_key" deferrable;
ERROR:  constraint "foo_a_b_key" of relation "foo" is not a foreign key constraint


​A more clear error message would be:

EROR:  cannot alter non-foreign key constraint "foo_a_b_key"​ of relation "foo"

Though I'm not sure how that meshes with the error message style guides...

David J.

pgsql-general by date:

Previous
From: Lisandro
Date:
Subject: [GENERAL] Re: GMT FATAL: remaining connection slots are reserved fornon-replication superuser connections, but I'm using pgBouncer forconnection pooling
Next
From: Ivan Voras
Date:
Subject: Re: [GENERAL] Making a unique constraint deferrable?