pg_toast record in table pg_class

Поиск
Список
Период
Сортировка
Искать
От
Mihail Nasedkin
Тема
pg_toast record in table pg_class
Дата
Msg-id
2a6880830909240152n7d0d24d6y84a5e7d8b57f3303@mail.gmail.com
Ответ на
Список
Hi.

I accidentally deleted pg_toast record from pg_class table that
belongs to regular table (reltoastrelid).

Now [select * from table_name] not work:
ERROR:  could not open relation with OID [oid_of_pg_toast_table]

Is it possible to restore corruption table?


--
---
Regards,
M.Nasedkin
В списке pgsql-general по дате отправления
От: Brendan Hill
Дата:
От: Bryan Montgomery
Дата:
FAQ