pg_toast record in table pg_class

From: Mihail Nasedkin <m(dot)nasedkin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_toast record in table pg_class
Date: 2009-09-24 08:52:49
Message-ID: 2a6880830909240152n7d0d24d6y84a5e7d8b57f3303@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Isabella Ghiurea 2009-09-24 20:26:49 db size and tables size difference
Previous Message Mihail Nasedkin 2009-09-24 05:45:02 pg_toast record in table pg_class

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-09-24 11:04:31 Re: Looking for way to replicate master db to multiple mobile databases
Previous Message Mihail Nasedkin 2009-09-24 05:45:02 pg_toast record in table pg_class