Sounds to me like your using an old version of psql with the new database -- it will show the stale columns, but they're not really there.
On Sun, 2002-12-01 at 07:27, Ruslan A Dautkhanov wrote: > Hi all, > > > isbs=# select version(); > version > ------------------------------------------------------------------- > PostgreSQL 7.3 on i386-unknown-freebsd4.7, compiled by GCC 2.95.4 > (1 row) > > isbs=# create table abba (x int4, y int4); > CREATE TABLE > isbs=# \d abba > Table "abba" > Column | Type | Modifiers > --------+---------+----------- > x | integer | > y | integer | > > isbs=# alter table abba drop column x; > ALTER TABLE > isbs=# \d abba > Table "abba" > Column | Type | Modifiers > ------------------------------+---------+----------- > ........pg.dropped.1........ | integer | > y | integer | > > > Why the first column not really deleted from table? How to make it work? > I tries using VACUUM FULL abba, but this didn't help. Thanks a lot for comments. > > > P.S. btw, I upgrade my DBs from 7.2.1 to 7.3 version without any problems, but > found, that psql's help messages (\h, \h alter table etc.) not from 7.3 > version. For example, it do not contain \h CREATE SCHEMA help message. > > > -- > best regards, > Ruslan A Dautkhanov [EMAIL PROTECTED] -- Rod Taylor <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
