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
Hi!
The manual states here:
http://www.postgresql.org/docs/current/static/sql-createtable.html
DEFERRABLE
NOT DEFERRABLE
This controls whether the constraint can be deferred. A constraint that is
not deferrable will be checked immediately *after every command*.
Checking of constraints
