Horton

reindex

Andrew Bartley <abartley@evolvosystems.com>

View thread View on postgr.es
From: "Andrew Bartley" <abartley@evolvosystems.com>
To: <pgsql-general@postgresql.org>
Date: 2003-02-25T05:04:53Z
Lists: pgsql-general 
Hi all,

I am having trouble reindexing our DB.

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

Can someone help me.

Thanks

Andrew Bartley