duplicate key - Mailing list pgsql-ru-general

From Dmitriy MiksIr
Subject duplicate key
Date
Msg-id hr9krj$vj8$1@dough.gmane.org
Whole thread Raw
Responses Re: duplicate key
List 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)

Вот это же ненормально?

pgsql-ru-general by date:

Previous
From: Maxim Tyurin
Date:
Subject: Re: Re: [pgsql-ru-general] Re:[pgsql-ru-general] Re: [pgsql-ru-general] Рассылка + Postgres
Next
From: Dmitriy MiksIr
Date:
Subject: Re: duplicate key