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

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Where does postgres store records of DROP-ed columns?
Дата
Msg-id 4140B6BC.6080105@commandprompt.com
обсуждение исходный текст
Ответ на Where does postgres store records of DROP-ed columns?  (pw <p.willis@telus.net>)
Ответы Re: Where does postgres store records of DROP-ed columns?  (peter Willis <peterw@borstad.com>)
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Memory exhausted (leak?)
Следующее
От: pw
Дата:
Сообщение: pg_attribute.attname