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(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "Man, I'm pretty. Hoo Hah!" |
| Johnny Bravo |
+---------------------------------------------------------------+