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 [EMAIL PROTECTED])
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
