types of constraint deferment - PostgreSQL Database

Ron Johnson

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

Subscribe Post Reply

2472

Stephan Szabo

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

Dennis Gearon

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

Ron Johnson

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

Stephan Szabo

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

Dennis Gearon

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

Similar topics

fundamental types

by: Kyle Kolander | last post by:

Sorry, I sent this to comp.std.c++ and meant to send it here as well... Why are the minimum size guarantees for fundamental types intentionally omitted from section 3.9.1 Fundamental types of...

C / C++

Why in stdint.h have both least and fast integer types?

by: GS | last post by:

The stdint.h header definition mentions five integer categories, 1) exact width, eg., int32_t 2) at least as wide as, eg., int_least32_t 3) as fast as possible but at least as wide as, eg.,...

C / C++

Which CHECK constraint causes the exception?

by: ferg | last post by:

I have a Customer table. The table has two different CHECK constraints. Then there is the Customer details dialog, which provides the user with an UI for changing users. I have some UPDATE sql,...

C# / C Sharp

How to add a constraint of Nullable Types to a generics method

by: Joe Bloggs | last post by:

Hi, compiling the following code: public class App { static void Main() { int? x = 5; bool? i = null;

C# / C Sharp

Generics constraint for nullable or reference types

by: Sam Kong | last post by:

Hello, I want to define a generic class which should accept only nullable types or reference types. What's the best way to costrain it? --------- class MyClass<T>{ ...

C# / C Sharp

Classification of arithmetic types

by: jacob navia | last post by:

As Richard Bos rightly pointed out, I had left in my classification of types the C99 types Complex and boolean. Here is a new classification. Those are not mentioned in the classification of...

C / C++

randomly generate n of each of two types

by: Alan Isaac | last post by:

I need access to 2*n random choices for two types subject to a constraint that in the end I have drawn n of each. I first tried:: def random_types(n,typelist=): types = typelist*n...

Python

converting strings to most their efficient types '1' --> 1, 'A' ---> 'A', '1.2'---> 1.2

by: py_genetic | last post by:

Hello, I'm importing large text files of data using csv. I would like to add some more auto sensing abilities. I'm considing sampling the data file and doing some fuzzy logic scoring on the...

Python

[SQLServer] Violation of UNIQUE KEY constraint

by: rorajoey | last post by:

Violation of UNIQUE KEY constraint 'IX_surveyQuestions'. Cannot insert duplicate key in object 'dbo.surveyQuestions'. This might seem like a simple matter of trying to insert a row with ID=20 when...

Microsoft SQL Server

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice