Re: Deleting a COL

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: "John M(dot) Flinchbaugh" <glynis(at)butterfly(dot)hjsoft(dot)com>
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Antonio Lagnada <lagnada(at)tbsoa(dot)com>, Pgsql-sql <pgsql-sql(at)postgresql(dot)org>, olly(at)linda(dot)lfix(dot)co(dot)uk
Subject: Re: Deleting a COL
Date: 2000-04-02 06:19:21
Message-ID: 200004020619.e326JNR25355@linda.lfix.co.uk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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(dot)Elphick(at)lfix(dot)co(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message swohaagh 2000-04-02 09:55:53 SPSS
Previous Message John M. Flinchbaugh 2000-04-02 05:50:19 Re: Deleting a COL