Message-ID: <51A7B815.6000404@gmx.net>
Date: Thu, 30 May 2013 16:35:33 -0400
From: Peter Eisentraut <peter_e@gmx.net>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8;
	rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version: 1.0
To: Erwin Brandstetter <brandstetter@falter.at>
CC: pgsql-docs@postgresql.org
Subject: Re: Contradicting information for DEFERRABLE constraints
References: <519FAC78.7090603@falter.at>
In-Reply-To: <519FAC78.7090603@falter.at>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

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.


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs