Postgres Pro
Downloads
Home   >   mailing lists

Re: constraint deferred but fails? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: constraint deferred but fails?
Date
Msg-id CAKFQuwYSELmpEHtaywi3v0Msx6UphX8ygjr0OL5OLc8vXbBZdA@mail.gmail.com
Whole thread Raw
In response to constraint deferred but fails?  (Nagy László Zsolt <gandalf@shopzeus.com>)
Responses Re: constraint deferred but fails?  (Nagy László Zsolt <gandalf@shopzeus.com>)
List pgsql-admin
Tree view
On Wednesday, January 23, 2019, Nagy László Zsolt <gandalf@shopzeus.com> wrote:
master=> SET CONSTRAINTS doc.fk_book_display_mode_id DEFERRED;

The constraint itself has to be changed to deferrable in order for it to be affected by the above.

David J. 
 

pgsql-admin by date:

Previous
From: Nagy László Zsolt
Date:
Subject: constraint deferred but fails?
Next
From: Nagy László Zsolt
Date:
Subject: Re: constraint deferred but fails?