> Hmmm. What did you do to "delete that table" exactly? The crash
To tell the truth, I delete the table using Windows PgAdmin. I guess it has
done the same operation, hasn't it?
> suggests that there is a row in pg_rewrite that links to a nonexistent
> row in pg_class. It'd be better if pg_dump emitted a more useful
> failure message, of course,
It would be nice if pg_dump could backup the information from other tables,
not only showing failure message.
> but the real question is how did your system catalogs get into such a
I agree. I ask people at #postgres for tools to check state of the DB, if
alive or corrupt, because in other cases I could only guess that something
is wrong when pg_dump fails. Would you like me to send you a copy of data?
In response to
pgsql-bugs by date
|Next:||From: John Smith||Date: 2005-03-15 17:43:15|
|Subject: BUG #1547: CREATE TYPE AS error|
|Previous:||From: Ales Vojacek||Date: 2005-03-15 07:59:31|
|Subject: Problem with restore DB|