Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA98146 for ; Sun, 2 Apr 2000 01:22:19 -0500 (EST) (envelope-from olly@lfix.co.uk) Received: from linda.lfix.co.uk (max03-066.enterprise.net [194.72.196.66]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id HAA20727; Sun, 2 Apr 2000 07:22:17 +0100 (GMT/BST) Received: from lfix.co.uk (localhost [127.0.0.1]) by linda.lfix.co.uk (8.10.0/8.10.0/Debian 8.10.0-1) with ESMTP id e326JNR25355; Sun, 2 Apr 2000 07:19:24 +0100 Message-Id: <200004020619.e326JNR25355@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.1.1 10/15/1999 (debian) To: "John M. Flinchbaugh" cc: Oliver Elphick , Antonio Lagnada , Pgsql-sql , olly@linda.lfix.co.uk Subject: Re: Deleting a COL In-Reply-To: Message from "John M. Flinchbaugh" of "Sun, 02 Apr 2000 00:50:19 CDT." References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sun, 02 Apr 2000 07:19:21 +0100 From: "Oliver Elphick" X-Archive-Number: 200004/11 "John M. Flinchbaugh" wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >On Sat, 1 Apr 2000, Oliver Elphick wrote: >> ALTER TABLE DROP COLUMN colname >> (but I don't think it's supported before release 7.0) > >just a note, if it is supported, it is not documented yet in psql, or man >alter_table of pgsql 7.0beta3. Sorry, I think I was confusing it with something else. The syntax is supported in the parser, but: junk=# alter table t2 drop column name restrict; ERROR: ALTER TABLE / DROP COLUMN is not implemented -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "If the Son therefore shall make you free, ye shall be free indeed." John 8:36