Postgres Pro
Downloads
Home   >   mailing lists

pg_toast record in table pg_class - Mailing list pgsql-general

From Mihail Nasedkin
Subject pg_toast record in table pg_class
Date
Msg-id 2a6880830909240152n7d0d24d6y84a5e7d8b57f3303@mail.gmail.com
Whole thread Raw
List pgsql-general
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 table?


--
---
Regards,
M.Nasedkin

pgsql-general by date:

Previous
From: "Brendan Hill"
Date:
Subject: Re: Idle processes chewing up CPU?
Next
From: Bryan Montgomery
Date:
Subject: Re: Looking for way to replicate master db to multiple mobile databases