raghu ram <raghuchennuru@xxxxxxxxx> hat am 21. Oktober 2011 um 17:12 geschrieben: > > > On Fri, Oct 21, 2011 at 8:33 PM, Emi Lu<emilu@xxxxxxxxxxxxxxxxx>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'; > > No, don't manipulate pg_* - tables. Use instead ALTER TABLE ... DISABLE TRIGGER ... Regards, Andreas > > --Raghu > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
