Horton

Re: reindex

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Andrew Bartley" <abartley@evolvosystems.com>
Cc: pgsql-general@postgresql.org
Date: 2003-02-25T15:02:16Z
Lists: pgsql-general 
"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