| From: | Dmitriy MiksIr <miksir(at)maker(dot)ru> |
|---|---|
| To: | pgsql-ru-general(at)postgresql(dot)org |
| Subject: | duplicate key |
| Date: | 2010-04-28 15:39:31 |
| Message-ID: | hr9krj$vj8$1@dough.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-ru-general |
После переезда на 8.4.3 и кручения всяких параметов в конфиге очень
редко ловлю такую вот ошибку.
postgres[5500]: [3-1] ERROR: duplicate key value violates unique
constraint "acm_topic_markers_marker_forum_id_idx"
postgres[5500]: [3-2] STATEMENT: DELETE FROM acm_topic_markers WHERE
marker_member_id = '16993' AND marker_forum_id = '383';
postgres[5500]: [3-3] INSERT INTO acm_topic_markers
(marker_member_id,marker_forum_id,...) VALUES(16993,383,...);
(в последнем операторе многоточием убрал лишнее)
Indexes:
"acm_topic_markers_marker_forum_id_idx" UNIQUE, btree
(marker_forum_id, marker_member_id)
Вот это же ненормально?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitriy MiksIr | 2010-04-28 17:37:57 | Re: duplicate key |
| Previous Message | Maxim Tyurin | 2010-03-28 11:17:54 | Re: Re: [pgsql-ru-general] Re: [pgsql-ru-general] Re: [pgsql-ru-general] Рассылка + Postgres |