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
2019-01-24 07:39 keltezéssel, David G. Johnston írta:
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.