rebuilding a table from a datafile
| От | brianb-pggeneral@edsamail.com |
|---|---|
| Тема | rebuilding a table from a datafile |
| Дата | |
| Msg-id | 20000816143610.9220.qmail@mail01.edsamail.com.ph обсуждение исходный текст |
| Ответы |
Re: rebuilding a table from a datafile
Re: rebuilding a table from a datafile |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: