This is with regards to Postgres 6.5.
While trying to ALTER RENAME a large table (203MB data file), an error
occured. \d displays the new table name, but there is no corresponding
file. a file with the original table name still exists, so presumably the
data is not lost. Is it possible for me to undo the RENAME by massaging the
pg_* tables, or otherwise retrieve the data in the table? It was an
insert-only table, and no deletes or updates were ever performed on it.
Brian
--
Brian Baquiran <brianb@edsamail.com>
http://www.baquiran.com/ AIM: bbaquiran
Work: +63(2)7182222 Home: +63(2) 9227123
I'm smarter than average. Therefore, average, to me, seems kind of stupid.
People weren't purposely being stupid. It just came naturally.
-- Bruce "Tog" Toganazzini