INFO: analyzing "pg_catalog.pg_type"
INFO: "pg_type": 5731 pages, 265 rows sampled, 265 estimated total rows
INFO: vacuuming "pg_catalog.pg_attribute"
ERROR: failed to re-find parent key in "pg_attribute_relid_attnam_index"

I get this error when I run Vacuum verbose analyze, any ideas? I
recently re-created a number of tables and indexes b/c we needed to
change to bigints.


Thanks
Michael

---------------------------(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

Michael Guerin <guerin (AT) rentec (DOT) com> writes:
Oh? What PG version is this exactly?

Your best bet is probably to REINDEX pg_attribute, but it would be wise
to try to understand what happened before you wipe out the evidence...

regards, tom lane

---------------------------(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

Tom Lane wrote:

search the logs for anything meaningful, should I look elsewhere?

thanks
michael


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org