Re: The difference between RESTRICT and NO ACTION

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.