subject:"\[ADMIN\] pg_toast record in table pg_class"

Re: [ADMIN] pg_toast record in table pg_class

2009-09-24 Thread Mihail Nasedkin

2009/9/24 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?

[ADMIN] pg_toast record in table pg_class

2009-09-23 Thread 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? -- --- Regards, M.Nasedkin