X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7E3CED1E2E2 for ; Tue, 23 Mar 2004 00:31:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38064-03 for ; Mon, 22 Mar 2004 20:31:56 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 81951D1CCA7 for ; Mon, 22 Mar 2004 20:31:43 -0400 (AST) Received: (qmail 7834 invoked by uid 500); 23 Mar 2004 00:34:56 -0000 Date: Mon, 22 Mar 2004 18:34:56 -0600 From: Bruno Wolff III To: Erik Thiele Cc: pgsql-sql@postgresql.org, pgsql-docs@postgresql.org Subject: Re: [SQL] special integrity constraints Message-ID: <20040323003456.GA7733@wolff.to> Mail-Followup-To: Erik Thiele , pgsql-sql@postgresql.org, pgsql-docs@postgresql.org References: <20040322102031.6a6f0b77.erik@thiele-hydraulik.de> <20040322112604.GA31222@wolff.to> <20040322141042.0aeb936d.erik@thiele-hydraulik.de> <20040322151211.GA2962@wolff.to> <20040322172121.72ecf58b.erik@thiele-hydraulik.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040322172121.72ecf58b.erik@thiele-hydraulik.de> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/50 X-Sequence-Number: 2340 On Mon, Mar 22, 2004 at 17:21:21 +0100, Erik Thiele wrote: > > there is no such thing as a deferred check constraint: > > 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 that are deferrable may be postponed until the > end of the transaction (using the SET CONSTRAINTS command). NOT > DEFERRABLE is the default. > > !!! Only foreign key constraints currently accept > this clause. All other constraint types are not deferrable. !!! Sorry, I checked the syntax for CREATE TABLE in the documentation and it shows DEFERRABLE as allowed on any column constraint. However, that is apparently not correct.