May 2018
Intermediate to advanced
576 pages
30h 25m
English
Unique and exclusion constraints can be marked as deferrable, meaning that the user can choose to postpone the check to the end of the transaction, a nice way to relax constraints without reducing data integrity. However, as of PostgreSQL 10, there are a few limitations that you should be aware of; the restrictions are as follows: