By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,789 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,789 IT Pros & Developers. It's quick & easy.

types of constraint deferment

P: n/a
Hi,

v7.3.3
http://www.postgresql.org/docs/7.3/s...eatetable.html

Is "INITIALLY DEFERRED" a modifier of "NOT DEFERRABLE"? If so,
what does it do, since they seem contradictory.

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #1
Share this Question
Share on Google+
5 Replies

P: n/a

On 11 Aug 2003, Ron Johnson wrote:
v7.3.3
http://www.postgresql.org/docs/7.3/s...eatetable.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? :)
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #2

P: n/a
I don't believe they work together.

Ron Johnson wrote:
Hi,

v7.3.3
http://www.postgresql.org/docs/7.3/s...eatetable.html

Is "INITIALLY DEFERRED" a modifier of "NOT DEFERRABLE"? If so,
what does it do, since they seem contradictory.

Thanks

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #3

P: n/a
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/s...eatetable.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: ro***********@cox.net |
| Jefferson, LA USA |
| |
| "Man, I'm pretty. Hoo Hah!" |
| Johnny Bravo |
+---------------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #4

P: n/a

On 12 Aug 2003, Ron Johnson wrote:
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/s...eatetable.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!!!!!


Basically, you can specify one of the following states on the constraint
(unless I'm missing something)

Neither a check time nor a deferrability, in which case you get
NOT DEFERRABLE INITIALLY IMMEDIATE
No check time and NOT DEFERRABLE, in which case you get
NOT DEFERRABLE INITIALLY IMMEDIATE
No check time and DEFERRABLE, in which case you get
DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY IMMEDIATE and no deferrability, in which case
you get NOT DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY DEFERRED and no deferrability, in which case
you get DEFERRABLE INITIALLY DEFERRED
A check time of INITIALLY IMMEDIATE and NOT DEFERRABLE, in which case
you get NOT DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY IMMEDIATE and DEFERRABLE, in which case
you get DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY DEFERRED and DEFERRABLE, in which case
you get DEFERRABLE INITIALLY DEFERRED
A check time of INITIALLY DEFERRED and NOT DEFERRABLE is an error
condition.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #5

P: n/a
Boy, that'd be nice to have in the manual!

Stephan Szabo wrote:
On 12 Aug 2003, Ron Johnson wrote:

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/s...eatetable.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!!!!!

Basically, you can specify one of the following states on the constraint
(unless I'm missing something)

Neither a check time nor a deferrability, in which case you get
NOT DEFERRABLE INITIALLY IMMEDIATE
No check time and NOT DEFERRABLE, in which case you get
NOT DEFERRABLE INITIALLY IMMEDIATE
No check time and DEFERRABLE, in which case you get
DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY IMMEDIATE and no deferrability, in which case
you get NOT DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY DEFERRED and no deferrability, in which case
you get DEFERRABLE INITIALLY DEFERRED
A check time of INITIALLY IMMEDIATE and NOT DEFERRABLE, in which case
you get NOT DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY IMMEDIATE and DEFERRABLE, in which case
you get DEFERRABLE INITIALLY IMMEDIATE
A check time of INITIALLY DEFERRED and DEFERRABLE, in which case
you get DEFERRABLE INITIALLY DEFERRED
A check time of INITIALLY DEFERRED and NOT DEFERRABLE is an error
condition.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.