Обсуждение: pg_toast record in table pg_class

Поиск
Список
Период
Сортировка

pg_toast record in table pg_class

От
Mihail Nasedkin
Дата:
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