> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
