Skip site navigation (1) Skip section navigation (2)

duplicate key

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 (view raw or flat)
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)

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


Responses

pgsql-ru-general by date

Next:From: Dmitriy MiksIrDate: 2010-04-28 17:37:57
Subject: Re: duplicate key
Previous:From: Maxim TyurinDate: 2010-03-28 11:17:54
Subject: Re: Re: [pgsql-ru-general] Re: [pgsql-ru-general] Re: [pgsql-ru-general] Рассылка + Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group