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

Where does postgres store records of DROP-ed columns?

From
pw
Date:
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



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

From
"Joshua D. Drake"
Date:
> 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@postgresql.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@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

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

From
Tom Lane
Date:
pw <p.willis@telus.net> writes:
> How do I get rid of these references?

You ignore pg_attribute rows that have attisdropped true.

            regards, tom lane

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

From
peter Willis
Date:
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
>