Re: duplicate key value violates unique constraint and duplicated records

From: Timokhin Maxim <ncx2(at)yandex(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: duplicate key value violates unique constraint and duplicated records
Date: 2017-06-30 09:50:45
Message-ID: 1925951498816245@web45g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div>Yes, you are right. It's just a typo.</div><div> </div><div>-- <br />Пожалуйста!</div><div>Используйте кнопку "ответить всем".</div><div>Не удаляйте историю переписки.</div><div>Спасибо. С уважением, Timokhin 'maf' Maxim</div><div> </div><div> </div><div> </div><div>30.06.2017, 02:38, "Adrian Klaver" &lt;adrian(dot)klaver(at)aklaver(dot)com&gt;:</div><blockquote type="cite"><p>On 06/29/2017 02:28 AM, Timokhin Maxim wrote:</p><blockquote> Hello.<br /> We are in process moving to new db from 9.4.8 -&gt; 9.6.3.1. When we did it<br /> our application started to throw exception "duplicate key value violates<br /> unique constraint" during doing INSERT:</blockquote><p><br />How did move from 9.4.8 --&gt; 9.6.3.1?<br /><br />Also where are you getting Postgres from? I ask because 9.6.3.1 is not<br />a community version or was that just a typo?<br /><br /><br /> </p><blockquote> Everything would be not bad if in the table weren't appeared duplicated<br /> records in url column.<br /> Any idea how is it possible?<br /> Thank you!<br /> --<br /> Timokhin 'maf' Maxim</blockquote><p><br /> </p><span>--<br />Adrian Klaver<br /><a href="mailto:adrian(dot)klaver(at)aklaver(dot)com">adrian(dot)klaver(at)aklaver(dot)com</a></span></blockquote>

Attachment Content-Type Size
unknown_filename text/html 1.3 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Timokhin Maxim 2017-06-30 11:58:32 Re: duplicate key value violates unique constraint and duplicated records
Previous Message Timokhin Maxim 2017-06-30 09:49:56 Re: duplicate key value violates unique constraint and duplicated records