dropped columns

From: Clarence Gardner <clarence(at)silcom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: dropped columns
Date: 2003-03-14 19:49:04
Message-ID: Pine.LNX.4.44.0303141136300.24397-100000@liberty.sba2.netlojix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-14 20:01:35 Re: The folding of unquoted names to lower case in PostgreSQL
Previous Message Rob Storrs 2003-03-14 19:40:18 Scope Problem with Execute?