Re: how should I do to disable the foreign key in postgres?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how should I do to disable the foreign key in postgres?
Date: 2007-11-18 07:58:23
Message-ID: 20071118075823.GA10196@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am Wed, dem 14.11.2007, um 15:16:48 +0800 mailte froast folgendes:
> in mysql, I used :"set foreign_key_check = 0;" to disable the foreign key
> check, now I'm trying to migrate from mysql to postgres, how should I do
> to disable it?

You can define the constraints as deferrable. Later you can say:

set constraints all deferred ;

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2007-11-18 11:00:26 Re: Compressed Backup too big
Previous Message Ron Johnson 2007-11-18 04:19:01 Re: Primary Key