From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Duplicate key |
Date: | 2003-09-08 18:21:11 |
Message-ID: | 23917.1063045271@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Gaetano Mendola" <mendola(at)bigfoot(dot)com> writes:
> I'm running Postgres 7.3.3 on a Linux Box
> I know that seems impossible,
> that I can not replicate the bug but
> today without hardware failure, power down etc etc
> I had a duplicate primary key + a duplicate unique index
> on one table. I already had this "kind" of problem in another
> table and I solved the problem not reindexing anymore that
> table, now this table have 12 index and is eavely updated/inserted
> so I must reindex this table once in a day.
What command have you been issuing, exactly? Also, let's see psql's \d
output for the table that's now got duplicate indexes, plus the pg_class
rows for the duplicate indexes.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2003-09-08 18:41:16 | stats on postgresql on various OSs |
Previous Message | Gaetano Mendola | 2003-09-08 17:26:39 | Duplicate key |