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,
>=20
>=20
> isbs=3D# select version();
> version
> -------------------------------------------------------------------
> PostgreSQL 7.3 on i386-unknown-freebsd4.7, compiled by GCC 2.95.4
> (1 row)
>=20
> isbs=3D# create table abba (x int4, y int4);
> CREATE TABLE
> isbs=3D# \d abba
> Table "abba"
> Column | Type | Modifiers
> --------+---------+-----------
> x | integer |
> y | integer |
>=20
> isbs=3D# alter table abba drop column x;
> ALTER TABLE
> isbs=3D# \d abba
> Table "abba"
> Column | Type | Modifiers
> ------------------------------+---------+-----------
> ........pg.dropped.1........ | integer |
> y | integer |
>=20
>=20
> 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 co=
mments.
>=20
>=20
> 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.
>=20
>=20
> --
> best regards,
> Ruslan A Dautkhanov rusland@scn.ru
--=20
Rod Taylor <rbt@rbt.ca>