Re: reindex

"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