| 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: | Whole Thread | Raw Message | 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
| 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 |