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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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