Disabling constraints

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Disabling constraints
Date: 2004-02-18 05:13:59
Message-ID: 00bf01c3f5f3$c62caae0$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear friends,

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?

Thanks
Kumar

Browse pgsql-sql by date

  From Date Subject
Next Message sad 2004-02-18 06:14:29 Re: bytea or blobs?
Previous Message Tom Lane 2004-02-18 05:10:05 Re: Indexes and statistics