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 5BD68D1B563 for ; Mon, 27 Oct 2003 19:50:21 +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 17632-04 for ; Mon, 27 Oct 2003 15:49:50 -0400 (AST) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 3B486D1B536 for ; Mon, 27 Oct 2003 15:49:49 -0400 (AST) Received: by emo.org.tr (Postfix, from userid 41643) id 7721AEE626; Mon, 27 Oct 2003 21:49:45 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id 71DB3EE614; Mon, 27 Oct 2003 21:49:45 +0200 (EET) Date: Mon, 27 Oct 2003 21:49:41 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: PostgreSQL Mailing Lists-SQL Cc: PostgreSQL Mailing Lists-SQL Subject: Re: Error with DROP column In-Reply-To: <62967.138.88.163.115.1067283344.squirrel@physics.gmu.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/351 X-Sequence-Number: 15751 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Mon, 27 Oct 2003 mohan@physics.gmu.edu wrote: > Hi All i am trying to DROP the column but i keep getting this error. > > ALTER TABLE institution DROP COLUMN name CASCADE; > ERROR: ALTER TABLE / DROP COLUMN is not implemented I think you are using an old version of PostgreSQL. AFAIR this functionality was implemented on 7.3. Here is mine: ******************************************* postgres@[local]:test=# SELECT version(); version - --------------------------------------------------------------------------------------------------------- PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5) (1 row) postgres@[local]:test=# ALTER TABLE institution drop column name; ALTER TABLE ******************************************* Maybe you should upgrade your PostgreSQL. Regards, - -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE/nXbYtl86P3SPfQ4RAqScAKDsSSSG7KYiM/TnBRguaG5hRF6MIACgwbfu ZdGWzsBbtu486c0BreFFlmA= =hFr5 -----END PGP SIGNATURE-----