Re: types of constraint deferment - Mailing list pgsql-general

From Stephan Szabo
Subject Re: types of constraint deferment
Date
Msg-id 20030811222654.K97310-100000@megazone.bigpanda.com
Whole thread Raw
In response to types of constraint deferment  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: types of constraint deferment  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On 11 Aug 2003, Ron Johnson wrote:

> v7.3.3
> http://www.postgresql.org/docs/7.3/static/sql-createtable.html
>
> Is "INITIALLY DEFERRED" a modifier of "NOT DEFERRABLE"?  If so,
> what does it do, since they seem contradictory.

It's not allowed.  An INITIALLY DEFERRED constraint must not
be defined as NOT DEFERRABLE, although an INITIALLY DEFERRED
constraint that doesn't specify either is considered DEFERRABLE.
The docs refered to are weak on this, care to try a rewrite of
those parts? :)


pgsql-general by date:

Previous
From: Joel Burton
Date:
Subject: {REPOST, CLARIFIED} How to recognize PG SQL files?
Next
From: Stephan Szabo
Date:
Subject: Re: Update of foreign key values