Re: Contradicting information for DEFERRABLE constraints - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: Contradicting information for DEFERRABLE constraints
Date
Msg-id 51A7B815.6000404@gmx.net
Whole thread Raw
In response to Contradicting information for DEFERRABLE constraints  (Erwin Brandstetter <brandstetter@falter.at>)
List pgsql-docs
On 5/24/13 2:07 PM, Erwin Brandstetter wrote:
> My tests on Postgres 9.1 and 9.2 seem to confirm that the check for
> non-deferrable constraints happens *after every row*, not after every
> command.

That only applies to unique constraints, not to other kinds of
constraints.  That's why the unique constraint defer behavior is
described separately, but it's different from the normal constraint
defer behavior.


pgsql-docs by date:

Previous
From: Marko Tiikkaja
Date:
Subject: ALTER TABLE lock level
Next
From: Peter Eisentraut
Date:
Subject: Re: The Parser Stage: "plain ASCII text" ?