X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CCD83D1DD42 for ; Wed, 18 Feb 2004 07:49:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 11799-01 for ; Wed, 18 Feb 2004 03:49:01 -0400 (AST) Received: from smtp104.mail.sc5.yahoo.com (smtp104.mail.sc5.yahoo.com [66.163.169.223]) by svr1.postgresql.org (Postfix) with SMTP id 1E5F1D1DD1F for ; Wed, 18 Feb 2004 03:48:59 -0400 (AST) Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp104.mail.sc5.yahoo.com with SMTP; 18 Feb 2004 07:48:59 -0000 Message-ID: <00bf01c3f5f3$c62caae0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Disabling constraints Date: Wed, 18 Feb 2004 10:43:59 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A9_01C3F60C.1D814F40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/246 X-Sequence-Number: 16936 This is a multi-part message in MIME format. ------=_NextPart_000_00A9_01C3F60C.1D814F40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 disabl= ing and enabling a constraint, as follows. update pg_class set reltriggers=3D0 where relname =3D 'crm.activities'; update pg_class set reltriggers =3D count(*) from pg_trigger where pg_class= .oid=3Dtgrelid and relname=3D'crm.activities'; Also doesnt work.=20 Is there a way to do it? Thanks=20 Kumar ------=_NextPart_000_00A9_01C3F60C.1D814F40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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';=20 doesn't work.
 
I got some information from google, which says about in= direct=20 way of disabling and enabling a constraint, as follows.
update pg_class set reltriggers=3D0 where relname =3D= =20 'crm.activities';
update pg_class set reltriggers =3D count(*) from pg_t= rigger=20 where pg_class.oid=3Dtgrelid and relname=3D'crm.activities';
 
Also doesnt work.
 
Is there a way to do it?
 
Thanks
Kumar

------=_NextPart_000_00A9_01C3F60C.1D814F40--