Where does postgres store records of DROP-ed columns?

Started by pwover 21 years ago4 messagesgeneral
Jump to latest
#1pw
p.willis@telus.net

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

#2Joshua D. Drake
jd@commandprompt.com
In reply to: pw (#1)
Re: Where does postgres store records of DROP-ed columns?

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
#3peter Willis
peterw@borstad.com
In reply to: Joshua D. Drake (#2)
Re: Where does postgres store records of DROP-ed columns?

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:

Show quoted text

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

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: pw (#1)
Re: Where does postgres store records of DROP-ed columns?

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