Thread: dropped columns

When I do a "\d tablename", I see columns that I've dropped, in the form:
    ........pg.dropped.9........ | integer                |
but a coworker does not see them. We are using different versions of
psql (I, 7.2.2, he, 7.3.2) but I don't know what version of the server
we're using (we both use the same server).

In any case, in light of what I read about records not being rewritten
immediately when a column is added, if those columns are still in the
data records, and if so, what can be done to get rid of them? I tried
an update that modified every record, and that didn't help either.


Thanks

Clarence Gardner <clarence@silcom.com> writes:
> When I do a "\d tablename", I see columns that I've dropped, in the form:
>     ........pg.dropped.9........ | integer                |
> but a coworker does not see them. We are using different versions of
> psql (I, 7.2.2, he, 7.3.2) but I don't know what version of the server
> we're using (we both use the same server).

Evidently you are both on a 7.3 server (prior ones don't do DROP
COLUMN).  You should be using 7.3 psql to talk to a 7.3 server.
7.2 psql does not fully understand the 7.3 catalogs.

            regards, tom lane