Обсуждение: 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)
>