DROP COLUMN really work?
От | Ruslan A Dautkhanov |
---|---|
Тема | DROP COLUMN really work? |
Дата | |
Msg-id | 3DEA0027.478C1A97@scn.ru обсуждение исходный текст |
Ответы |
Re: DROP COLUMN really work?
|
Список | 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@scn.ru
В списке pgsql-bugs по дате отправления: