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.
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
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
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
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