Re: Deleting a COL

"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
ID32B8FAA1                ========================================    "If the Son therefore shall make you free, ye
shallbe      free indeed."         John 8:36