Disabling constraints - 02-17-2004 , 11:13 PM
I am working opn Postgres 7.3.4 on RH Linux 7.2.
I wanted to disable constraints.
Alter table 'table name' disable constraint 'constraint name'; doesn't work.
I got some information from google, which says about indirect way of disabling and enabling a constraint, as follows.
update pg_class set reltriggers=0 where relname = 'crm.activities';
update pg_class set reltriggers = count(*) from pg_trigger where pg_class..oid=tgrelid and relname='crm.activities';
Also doesnt work.
Is there a way to do it?