Обсуждение: BUG #4930: Missing attributes

The following bug has been logged online:

Bug reference:      4930
Logged by:          Stefan Kirchev
Email address:      stefan.kirchev@gmail.com
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
pnp=#

Restart of the database does not help.
Rebooting the server does not help either.

Is there any solution on this issue. I have been searching in the net for
the last few hours, but no clue found so far.
Thanks.

"Stefan Kirchev" <stefan.kirchev@gmail.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