Hosting Provided By

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

From: A. Kretschmer <andreas.kretschmer(at)schollglas.com>
Date: Sun Nov 18 2007 - 02:58:23 EST

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Received on Sun Nov 18 02:59:55 2007

This message: [ Message body ]
Next message: Filip RembiaÅ‚kowski: "Re: [GENERAL] Compressed Backup too big"
Previous message: Ron Johnson: "Re: [GENERAL] Primary Key"
In reply to: froast: "[GENERAL] how should I do to disable the foreign key in postgres?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 20:08:41 EDT