Re: REFRENTIAL INTEGRITY CHECKING

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)
>