Re: valid using INITIALLY DEFERRED - Mailing list pgsql-general

From Michael Fuhr
Subject Re: valid using INITIALLY DEFERRED
Date
Msg-id 20041222163255.GA15517@winnie.fuhr.org
Whole thread Raw
In response to valid using INITIALLY DEFERRED  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-general
On Wed, Dec 22, 2004 at 04:17:29PM +0100, Pavel Stehule wrote:

>   I try INITIALLY DEFERRED clause. In doc is relation between general
> constraint and this clause. But combination with CHECK clause ends with
> err message misplaced INITIALLY DEFERRED clause.

The CREATE TABLE documentation for INITIALLY DEFERRED says, "If a
constraint is deferrable, this clause specifies the default time
to check the constraint."  Just above that, the documentation for
DEFERRABLE says, "Only foreign key constraints currently accept
this clause.  All other constraint types are not deferrable."

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: DELETE versus TRUNCATE during pg_dump....
Next
From: John Cunningham
Date:
Subject: Re: postgresql.conf