X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 27189D1B465 for ; Tue, 30 Dec 2003 14:00:27 +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 99864-04 for ; Tue, 30 Dec 2003 09:59:40 -0400 (AST) Received: from Gateway.bksys.co.in (unknown [61.3.252.134]) by svr1.postgresql.org (Postfix) with ESMTP id 007A4D1B4A7 for ; Tue, 30 Dec 2003 09:59:35 -0400 (AST) Received: from Intranet.bksys.co.in (mail.bksys.co.in [192.168.1.1]) by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id hBUDxVq24610; Tue, 30 Dec 2003 19:29:31 +0530 Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71]) by Intranet.bksys.co.in (8.11.6/8.11.6) with ESMTP id hBUDxVx09102; Tue, 30 Dec 2003 19:29:31 +0530 Subject: Re: drop column From: "A.Bhuvaneswaran" To: Ashok Chauhan Cc: pgsql-admin@postgresql.org In-Reply-To: <1072804035.3479.6.camel@delta.greatindianproducts.com> References: <1072804035.3479.6.camel@delta.greatindianproducts.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-4+c+bDwASjjUbcUqCweK" Message-Id: <1072793069.1687.17.camel@Bhuvan.bksys.co.in> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 30 Dec 2003 19:34:29 +0530 X-Filter-Version: 1.11.Cvg (Gateway.bksys.co.in) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/342 X-Sequence-Number: 11848 --=-4+c+bDwASjjUbcUqCweK Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > A command for remove the column but it not work > it gives parse error > ALTER TABLE tablename DROP COLUMN fieldname; drop column feature is implemented since 7.3. So, you please check out your version. regards, bhuvaneswaran --=-4+c+bDwASjjUbcUqCweK Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA/8YXsL2UFujVh8ToRAqhoAJ4/8JnnXmRY8HVqTqE8/rnn/PFBxgCfcHLI QSAE5gdyfCiBUjEJqlLLF5k= =E7hn -----END PGP SIGNATURE----- --=-4+c+bDwASjjUbcUqCweK--