Bill Todd wrote:
In discussing foreign key constraints the manual makes the following
statement about the difference between RESTRICT and NO ACTION.
"(The essential difference between these two choices is that |NO
ACTION| allows the check to be deferred until later in the
transaction, whereas |RESTRICT| does not.)"
Can someone explain what this means in practical terms? Do both
options generate the same error message? Does "until later in the
transaction" mean that NO ACTION is not checked until an attempt is
made to commit the transaction?
If someone can point me to a more detailed explanation I would
appreciate it. Thanks.
Bill
After posting the question I found a more complete explanation in the
manual.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
