Re: [GENERAL] Temporally disabled foreign key constraint check?

2011-10-22 Thread raghu ram
On Fri, Oct 21, 2011 at 9:19 PM, Emi Lu em...@encs.concordia.ca wrote: Thank you first. I believe that upate pg_class can only be done by superuser, right? Yes,it's requires superuser privileges. Besides, if I need the whole schema's foreign keys to be disabled and then enabled later.

[GENERAL] Temporally disabled 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

Re: [GENERAL] Temporally disabled foreign key constraint check?

2011-10-21 Thread raghu ram
On Fri, Oct 21, 2011 at 8:33 PM, Emi Lu em...@encs.concordia.ca 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 You can disable *triggers* on a table

Re: [GENERAL] Temporally disabled foreign key constraint check?

2011-10-21 Thread Andreas Kretschmer
raghu ram raghuchenn...@gmail.com hat am 21. Oktober 2011 um 17:12 geschrieben: On Fri, Oct 21, 2011 at 8:33 PM, Emi Luem...@encs.concordia.cawrote: Good morning, Is there a way to temporally disabled foreign key constraints something like: SET FOREIGN_KEY_CHECKS=0

Re: [GENERAL] Temporally disabled foreign key constraint check?

2011-10-21 Thread Emi Lu
Thank you first. I believe that upate pg_class can only be done by superuser, right? Besides, if I need the whole schema's foreign keys to be disabled and then enabled later. Is there a simple command could do it? Similar to mysql's set FOREIGN_KEY_CHECKS = false/true? Emi On 10/21/2011