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 cobbled a way to do that as I do the pg_restore. But that raised a question of why not just make the constraints all "deferred" and simplify my pg_restore process. Are immediate constraints more efficient? Does this relate to transaction isolation in that the data would be consistent after each statement and therefor give better stability when multiple transactions are running at the same time? My brain is asking this question because so far in my experience, the issues with constraints are solved by making them deferred. If I made them immediate, would I just bump into a different set of issues whose solution would be to make the constraints immediate? Thank you, Perry
Attachment:
signature.asc
Description: Message signed with OpenPGP using GPGMail
