Re: [SQL] how to temporally disable foreign key constraint check

2011-10-21 Thread Craig Ringer
On 10/21/2011 09:36 PM, Emi Lu wrote: 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 If you really, really want to do this you can do it by disabling the triggers tha

Re: [SQL] how to temporally disable foreign key constraint check

2011-10-21 Thread Thomas Kellerer
Emi Lu wrote on 21.10.2011 15:36: 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 You can define the FKs as "DEFERRABLE INITIALLY IMMEDIATE". Then a

Re: [SQL] how to temporally disable foreign key constraint check

2011-10-21 Thread Emi Lu
Not really, sorry :( What I am looking for is no DB structure changes. But only disabling foreign key constraint check/verify for period of time and then recover it. Similar to mysql's "set FOREIGN_KEY_CHECKS = true/false" Emi On 10/21/2011 10:58 AM, Oliveiros d'Azevedo Cristina wrote: S

Re: [SQL] how to temporally disable foreign key constraint check

2011-10-21 Thread Oliveiros d'Azevedo Cristina
Something like ALTER TABLE t_yourtable DROP CONSTRAINT and then ALTER TABLE t_yourtable ADD FOREIGN KEY ? Best, Oliveiros - Original Message - From: "Emi Lu" To: Sent: Friday, October 21, 2011 2:36 PM Subject: [SQL] how to temporally disable foreign key constraint check Good m

[SQL] how to temporally disable foreign key constraint check

2011-10-21 Thread Emi Lu
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 em...@encs.concordia.ca+1 514 848-242