Re: types of constraint deferment

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                                               |
+---------------------------------------------------------------+