Re: REFRENTIAL INTEGRITY CHECKING

Поиск
Список
Период
Сортировка
От Thalis A. Kalfigopoulos
Тема Re: REFRENTIAL INTEGRITY CHECKING
Дата
Msg-id Pine.LNX.4.21.0107161443180.9097-100000@aluminum.cs.pitt.edu
обсуждение исходный текст
Ответ на REFRENTIAL INTEGRITY CHECKING  ("Sudheer Palaparambil" <p_sudheers@rediffmail.com>)
Ответы Re: REFRENTIAL INTEGRITY CHECKING  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Список 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@postgresql.org)
>


В списке pgsql-admin по дате отправления:

Предыдущее
От: s.chava@wcom.com (Srinivasa Rao Chava)
Дата:
Сообщение: connect failure from psql`
Следующее
От: "berger, ralf"
Дата:
Сообщение: AW: psql and lo_import