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

From Ron Johnson
Subject Re: types of constraint deferment
Date
Msg-id 1060675724.30770.21.camel@haggis
Whole thread Raw
In response to Re: types of constraint deferment  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: types of constraint deferment  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
On Tue, 2003-08-12 at 00:38, Stephan Szabo wrote:
> 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? :)

Sure, after I know what the rules are!!!!!

--
+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+



pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: remove $ from money field
Next
From: Richard Huxton
Date:
Subject: Re: Help! Can't pg_dump anything: handler procedure for procedural language plpgsql not found