Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9DC4747587E for ; Fri, 5 Jul 2002 07:56:30 -0400 (EDT) Mailbox-Line: From mallah@trade-india.com Fri Jul 5 07:56:30 2002 Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 2C31E475864 for ; Fri, 5 Jul 2002 07:56:22 -0400 (EDT) Received: (qmail 2926 invoked from network); 5 Jul 2002 11:49:41 -0000 Received: from system67.trade-india-local.com (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 5 Jul 2002 11:49:41 -0000 Content-Type: text/plain; charset="us-ascii" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: pgsql-sql@postgresql.org Subject: Is Dropping a column "CHECK" constraint possible? Date: Fri, 5 Jul 2002 17:29:42 +0530 User-Agent: KMail/1.4.1 MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200207051729.42137.mallah@trade-india.com> X-Spam-Status: No, hits=0.4 required=5.0 tests=X_NOT_PRESENT,SUBJ_ENDS_IN_Q_MARK,MIME_EXCESSIVE_QP version=2.30 X-Spam-Level: X-Archive-Number: 200207/56 X-Sequence-Number: 8435 Hi Folks , can anyone please help? i have a to drop a check contstraint from a column. eg tradein_clients=3D# \d t_a Table "t_a" Column | Type | Modifiers ------------+---------+----------- company_id | integer | exp | text | imp | text | Check constraints: "$1" (length(imp) > 1) "aaaaaq" (length(imp) > 1) Can i remove to contraints thru ALTER TABLE or similar commands. I have read the docs for ALTER TABLE but the command described is=20 not working for me. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D ALTER TABLE [ ONLY ] table DROP CONSTRAINT constraint { RESTRICT | CASCADE } =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D Regards Mallah. --=20 Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.