| From: | "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> |
|---|---|
| To: | Sudheer Palaparambil <p_sudheers(at)rediffmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: REFRENTIAL INTEGRITY CHECKING |
| Date: | 2001-07-16 18:48:16 |
| Message-ID: | Pine.LNX.4.21.0107161443180.9097-100000@aluminum.cs.pitt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)postgresql(dot)org)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-07-16 18:51:42 | Re: REFRENTIAL INTEGRITY CHECKING |
| Previous Message | Srinivasa Rao Chava | 2001-07-16 18:38:40 | connect failure from psql` |