Re: DROP COLUMN really work?

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 rusland(at)scn(dot)ru
--
Rod Taylor <rbt(at)rbt(dot)ca>