pg_toast record in table pg_class

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: pg_toast record in table pg_class
From: Mihail Nasedkin <m.nasedkin@xxxxxxxxx>
Date: Thu, 24 Sep 2009 11:45:02 +0600
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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

Follow-Ups:
- Re: pg_toast record in table pg_class
  - From: Mihail Nasedkin

Prev by Date: Re: db size and tables size difference
Next by Date: db size and tables size difference
Previous by thread: Authentication Postgres user via LDAP
Next by thread: Re: pg_toast record in table pg_class
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux