"Andrew Bartley" <abartley@evolvosystems.com> writes:
> We are running PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC gcc
> (GCC) 3.2.1
> backend> reindex database evolvo force
> NOTICE: relation 1247 was reindexed
> NOTICE: relation 1249 was reindexed
> NOTICE: relation 1259 was reindexed
> NOTICE: relation 1261 was reindexed
> NOTICE: relation 1262 was reindexed
> ERROR: cannot create pg_inherits_relid_seqno_index: File exists
If you've been running this database long enough to wrap around the OID
counter, then this failure is possible (though I wouldn't have thought
it probable). Try a few times and it'll probably succeed eventually.
regards, tom lane