From a logical standpoint, its like this.
The purpose of constraints is to have the DBMS enforce your concept of
consistency, wherein a database is consistent if any questions you ask it result
in a valid answer insofar as the database could possibly know.
Immediate constraints ensure that th
The direct question is: what is the advantage of an immediate constraint?
My habit is to add constraints to my databases and my first lesson was to make
them "deferrable". But a recent fight with pg_restore taught me that to do a
pg_restore that is complex, you need to defer the constraints. I
