Re: types of constraint deferment

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: types of constraint deferment
Date: 2003-08-12 05:38:02
Message-ID: 20030811222654.K97310-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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? :)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-08-12 05:51:00 Re: Update of foreign key values
Previous Message Joel Burton 2003-08-12 05:31:35 {REPOST, CLARIFIED} How to recognize PG SQL files?