DROP COLUMN really work?

From: Ruslan A Dautkhanov <rusland(at)scn(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: DROP COLUMN really work?
Date: 2002-12-01 12:27:19
Message-ID: 3DEA0027.478C1A97@scn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-12-01 13:05:39 Bug #827: pg_dump in 7.3 can't dump 7.1 db
Previous Message pgsql-bugs 2002-12-01 11:09:36 Bug #826: opaque->internal translation required for 7.2 dumps