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