Postgres Pro
Downloads
Home   >   mailing lists

pg_toast record in table pg_class - Mailing list pgsql-admin

From Mihail Nasedkin
Subject pg_toast record in table pg_class
Date
Msg-id 2a6880830909232245k5da4475blfd2e0cc48c02eb71@mail.gmail.com
Whole thread Raw
Responses Re: pg_toast record in table pg_class
List pgsql-admin
Tree view
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?


--
---
Regards,
M.Nasedkin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: db size and tables size difference
Next
From: Isabella Ghiurea
Date:
Subject: db size and tables size difference