i tried running postgres and did a reindex..
and i got this..
...................
NOTICE: relation 16596 was reindexed
NOTICE: relation 16598 was reindexed
NOTICE: relation 16384 was reindexed
NOTICE: relation 16386 was reindexed
NOTICE: relation 1262 was reindexed
ERROR: Cannot create unique index. Table contains non-unique values
backend>
is there other ways of doing fixing this?
TIA
On Thursday 17 July 2003 04:58, you wrote:
> jerome <jerome@gmanmi.tv> writes:
> > i was running postgres in foreground while doing a vaccum.. the vaccum
> > didnt finish its job because of a power failure...
> > i tried to reconnect to the db and i got this error when i issue a \d
> > (hoping to see the tables..)
> > ERROR: Cache lookup failed for relation 5741599
> > is there a way to retrieve my data..??
>
> You might find that reindexing the system indexes will get you out of
> trouble. See the REINDEX man page for the detailed procedure to follow;
> it's a bit messy...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html