| 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: | Whole Thread | Raw Message | 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 |