From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Duplicate key |
Date: | 2003-09-08 17:26:39 |
Message-ID: | bjiebm$s6c$1@floppy.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
Are we sure at 100% that the is not a reindex fault ?
What can I do next time in order to discover this nusty bug ?
BTW, I don't know if you got my past email about a strange
core by the postmaster that disappeared after that I change
the scheduling of a vacuum ( not anymore togheter with the
select that was causing the core ); well after almost 2 month
I still not having another core.
Regards
Gaetano Mendola
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-08 18:21:11 | Re: Duplicate key |
Previous Message | Kir ZK | 2003-09-08 16:07:28 | Problem |