Re: does this look more like a possible bug or more like a possible hardware problem...? (long)
| От | Frank van Vugt |
|---|---|
| Тема | Re: does this look more like a possible bug or more like a possible hardware problem...? (long) |
| Дата | |
| Msg-id | 200403101833.12972.ftm.van.vugt@foxi.nl обсуждение |
| Ответ на | does this look more like a possible bug or more like a possible hardware problem...? (long) (Frank van Vugt <ftm.van.vugt@foxi.nl>) |
| Список | pgsql-general |
> I'm sorry, I meant to say save a copy of > pg_attribute_relid_attnum_index. The correct filename for it can be > found via > select relfilenode from pg_class where relname = > 'pg_attribute_relid_attnum_index'; Got it, made a backup of the entire database as well. Since the db wasn't filled yet, both files are fairly small when bzipped (<0.5MB and < 5MB) and both can be made available if you want. Issuing 'reindex table pg_attribute' did not solve the problem, though.... > > Oid of table article_property_tree from database "megafox_trial": > > --------------------------------- > > VERY scary: more than one table with that name found!! > > Do you have more than one such table (presumably in different schemas)? > If so this isn't scary at all. I don't believe oid2name has been fixed > to be schema-aware :-( Nope, all user-tables are in public at the moment. Also: megafox_trial=# select * from article_property_tree; ERROR: catalog is missing 6 attribute(s) for relid 8349771 -- Best, Frank.
В списке pgsql-general по дате отправления: