Where does postgres store records of DROP-ed columns?
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
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
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