Re: BUG #4930: Missing attributes

"Stefan Kirchev" <stefan(dot)kirchev(at)gmail(dot)com> writes:
> PostgreSQL version: 8.3.3
> Operating system: Linux
> Description: Missing attributes
> Details:

> One of the tables failed to drop and now it causes pg_dump crash. The table
> was used for temporary storage and the drop query went just fine. Even
> though the table name is still in the pg_tables. Trying to drop it again
> produces the following error:
> pnp=# drop table tmp_msc_data_todiot;
> ERROR: catalog is missing 33 attribute(s) for relid 1536137

I think this might be another variant of the issue reported at bug
#4929: you've got a pg_class row that somehow got un-marked as deleted.

> Is there any solution on this issue.

Well, first off you need to update to 8.3.4 or later. What I'd try then
is manually DELETE the pg_class row for that table name, then pg_dump,
initdb, reload.

regards, tom lane