Re: DROP COLUMN really work? - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: DROP COLUMN really work?
Date
Msg-id 1038751681.72409.178.camel@jester
Whole thread Raw
In response to DROP COLUMN really work?  (Ruslan A Dautkhanov <rusland@scn.ru>)
List pgsql-bugs
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>

pgsql-bugs by date:

Previous
From: Philip Warner
Date:
Subject: Re: Bug #827: pg_dump in 7.3 can't dump 7.1 db
Next
From: Adam Buraczewski
Date:
Subject: contrib/adddepend does not properly re-create multi-column foreign keys.