Re: Where does postgres store records of DROP-ed columns? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Where does postgres store records of DROP-ed columns?
Date
Msg-id 4140B6BC.6080105@commandprompt.com
Whole thread Raw
In response to Where does postgres store records of DROP-ed columns?  (pw <p.willis@telus.net>)
Responses Re: Where does postgres store records of DROP-ed columns?  (peter Willis <peterw@borstad.com>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Memory exhausted (leak?)
Next
From: pw
Date:
Subject: pg_attribute.attname