From: Kumar <sgnerd@yahoo.com.sg>
To: psql <pgsql-sql@postgresql.org>
Subject: Disabling constraints
Date: Wed, 18 Feb 2004 10:43:59 +0530
Message-ID: <00bf01c3f5f3$c62caae0$7502a8c0@hdsc.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg
Subject: Re: Disabling constraints
In-Reply-To: <00bf01c3f5f3$c62caae0$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox