X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 50AF13AA4C7 for ; Fri, 10 Dec 2004 22:40:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04697-01 for ; Fri, 10 Dec 2004 22:39:35 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id 888563B4602 for ; Fri, 10 Dec 2004 18:51:26 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr4.postgresql.org (Postfix) with ESMTP id F183A5AF9DD for ; Tue, 7 Dec 2004 18:19:33 +0000 (GMT) Received: from ltarividar ([82.221.52.8] [82.221.52.8]) by quasar.skima.is with ESMTP; Tue, 7 Dec 2004 18:16:59 Z From: "Ari Johannesson" To: Subject: How to temporarily disable referntial integrity? Date: Tue, 7 Dec 2004 18:17:48 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_007A_01C4DC89.0E90AFD0" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcTcgtdCV3FJEpKnQDyVsqt7Ni+U/A== Message-Id: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/95 X-Sequence-Number: 15681 This is a multi-part message in MIME format. ------=_NextPart_000_007A_01C4DC89.0E90AFD0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have data to import into a postgres database. The data is referentially sound but during the insert it breaks som foreign-key constraints. Is there a way to turn off the referential integrity during the insert? Thanks, Ari Johannesson ------=_NextPart_000_007A_01C4DC89.0E90AFD0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have data to import into a postgres database. The = data is referentially sound but during the insert it breaks som foreign-key constraints. Is there a way to turn off the referential integrity during = the insert?

 

Thanks,

Ari Johannesson

------=_NextPart_000_007A_01C4DC89.0E90AFD0--