Postgres Pro
Downloads
Home   >   mailing lists

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

From pw
Subject Where does postgres store records of DROP-ed columns?
Date
Msg-id 4140A880.2070208@telus.net
Whole thread Raw
Responses Re: Where does postgres store records of DROP-ed columns?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Where does postgres store records of DROP-ed columns?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: How to determine a database is intact?
Next
From: Bruno Wolff III
Date:
Subject: Re: Obtaining the Julian Day from a date