Skip site navigation (1) Skip section navigation (2)

how to temporally disable foreign key constraint check

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: how to temporally disable foreign key constraint check
Date: 2011-10-21 13:36:34
Message-ID: 4EA17562.4030202@encs.concordia.ca (view raw or flat)
Thread:
Lists: pgsql-sql
Good morning,


Is there a way to temporally disabled foreign key constraints something 
like

SET FOREIGN_KEY_CHECKS=0

When population is done, will set FOREIGN_KEY_CHECKS=1

Thanks a lot!
Emi

-- 
Emi Lu, ENCS, Concordia University, Montreal H3G 1M8
emilu(at)encs(dot)concordia(dot)ca        +1 514 848-2424 x5884

Responses

pgsql-sql by date

Next:From: Oliveiros d'Azevedo CristinaDate: 2011-10-21 14:58:03
Subject: Re: how to temporally disable foreign key constraint check
Previous:From: Thomas KellererDate: 2011-10-20 12:14:23
Subject: Re: new user on mac

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group