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 11:12 AM, raghu ram wrote:
On Fri, Oct 21, 2011 at 8:33 PM, Emi Lu <em...@encs.concordia.ca <mailto: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 (which will disable all the FK constraints, but not things like 'not nul' or 'unique'). For Disable: update pg_class set reltriggers=0 where relname = 'TEST'; For Enable: update pg_class set reltriggers = count(*) from pg_trigger where pg_class.oid=tgrelid and relname='TEST'; --Raghu
-- Emi Lu, ENCS, Concordia University, Montreal H3G 1M8 em...@encs.concordia.ca +1 514 848-2424 x5884 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
