Re: [GENERAL] duplicate key value violates unique constraint and duplicated records

On 06/29/2017 02:28 AM, Timokhin Maxim wrote:

 Hello.
 We are in process moving to new db from 9.4.8 -> 9.6.3.1. When we did it
 our application started to throw exception "duplicate key value violates
 unique constraint" during doing INSERT:

How did move from 9.4.8 --> 9.6.3.1?

Also where are you getting Postgres from? I ask because 9.6.3.1 is not
a community version or was that just a typo?


 

 Everything would be not bad if in the table weren't appeared duplicated
 records in url column.
 Any idea how is it possible?
 Thank you!
 --
 Timokhin 'maf' Maxim

 --
Adrian Klaver
adrian.klaver@aklaver.com