"Stefan Kirchev" <stefan.kirc...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
