Re: Foreign Key Deferrable Misunderstanding or Bug? - Mailing list pgsql-general

Paul Rogers <progers@sparkbase.com> writes:
> Why does the attached script fail with a foreign key constraint violation?

The ON DELETE RESTRICT is why.  Per the fine manual:

    [RESTRICT] is the same as NO ACTION except that the check is not
    deferrable.

It's a bit odd, but that's the best interpretation we can make of the
spec's wording about how this should work.

            regards, tom lane