Re: [GENERAL] major database breakdown

2004-08-17 Thread Tom Lane
Ulrich Wisser <[EMAIL PROTECTED]> writes: > I did delete everything from pg_statistic. It helped somewhat but > still there is something strange. Please see the transcript of my > session below. How can I fix these broken indexes? I can't drop and > recreate them. I am not sure what's going on w

Re: [GENERAL] major database breakdown

2004-08-16 Thread Tom Lane
Ulrich Wisser <[EMAIL PROTECTED]> writes: > backend> REINDEX DATABASE "CLIX1" > NOTICE: relation 16416 was reindexed > NOTICE: relation 1255 was reindexed > ... > NOTICE: relation 16384 was reindexed > NOTICE: relation 16386 was reindexed > ERROR: Cannot create unique index. Table contains non