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?
pgsql-sql by date
|Next:||From: sad||Date: 2004-02-18 06:14:29|
|Subject: Re: bytea or blobs?|
|Previous:||From: Tom Lane||Date: 2004-02-18 05:10:05|
|Subject: Re: Indexes and statistics |