Re: Where does postgres store records of DROP-ed columns?

Hello,

I have some stuff coming back from the database
telling me that columns that I have dropped
are being retined inthe table renamed as

........pg.dropped.1........
........pg.dropped.7........

I know what these columns originally were but I dropped them
from the table. I am now 'haunted' by these ghost columns with no
type applied.

How do I get rid of these references?

Thanks for nay help,

Pete

> I know what these columns originally were but I dropped them
> from the table. I am now 'haunted' by these ghost columns with no
> type applied.
>
> How do I get rid of these references?

I believe (I would have to double check) that they will dissappear after
a vacuum.

Sincerely,

Joshua D. Drake

>
> Thanks for nay help,
>
> Pete
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Thank you.
That worked.
I got mind locked into psql command line space and forgot about
the executables......

Thanks again,

Pete

Joshua D. Drake wrote:

>>
>> How do I get rid of these references?
>
>
> I believe (I would have to double check) that they will dissappear
> after a vacuum.
>
> Sincerely,
>
> Joshua D. Drake
>

pw <p(dot)willis(at)telus(dot)net> writes:
> How do I get rid of these references?

You ignore pg_attribute rows that have attisdropped true.

regards, tom lane