Thread: REFRENTIAL INTEGRITY CHECKING
Hi, How do we avoid referential integrity (FOREIGN KEY) checking till commit. My pgsql server is checking it as soon as I am issueing an INSERT command. Pls help. Thanks in advance. Sudheer ____________________________________________________ http://www.monsterindia.com - The Best Jobs. For the Best Minds.
--- Sudheer Palaparambil <p_sudheers@rediffmail.com> wrote: > Hi, > > How do we avoid referential integrity (FOREIGN > KEY) checking till commit. My pgsql server > is checking it as soon as I am issueing an INSERT > command. Pls help. When you define the constraint, set it as INITIALLY DEFERRED (or if you only sometimes want it to defer, set it as DEFERRABLE and use SET CONSTRAINTS to change the mode) However, there are some problems with the deferred ri right now if you modify the same key more than once in a transaction -- I'm hoping to get a chance to fix that for 7.2. For now, you have to be careful. __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
On 16 Jul 2001, Sudheer Palaparambil wrote: > Hi, > > How do we avoid referential integrity (FOREIGN KEY) checking till commit. My pgsql server > is checking it as soon as I am issueing an INSERT command. Pls help. > > Thanks in advance. SET CONSTRAINTS TO DEFERRED This will do the job only if your fk was not defined as INITIALLY IMMEDIATE NOT DEFERRABLE cheers, thalis > > Sudheer > > ____________________________________________________ > http://www.monsterindia.com - The Best Jobs. For the Best Minds. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
On Mon, 16 Jul 2001, Thalis A. Kalfigopoulos wrote: > On 16 Jul 2001, Sudheer Palaparambil wrote: > > > Hi, > > > > How do we avoid referential integrity (FOREIGN KEY) checking till commit. My pgsql server > > is checking it as soon as I am issueing an INSERT command. Pls help. > > > > Thanks in advance. > > SET CONSTRAINTS TO DEFERRED Sorry, it's actually: SET CONSTRAINTS <constraint_name> TO DEFERRED IF you don't want to give a specific constraint name, just give ALL. cheers, thalis > > This will do the job only if your fk was not defined as INITIALLY IMMEDIATE NOT DEFERRABLE > > cheers, > thalis > > > > > Sudheer > > > > ____________________________________________________ > > http://www.monsterindia.com - The Best Jobs. For the Best Minds. > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >