Re: constraint deferred but fails?

It is already deferrable:

ALTER TABLE doc.book ADD CONSTRAINT fk_book_display_mode_id FOREIGN KEY (display_mode_id) REFERENCES doc.display_mode(id) DEFERRABLE

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. 

 

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.