Re: duplicate primary key

2017-11-24 Thread Michael Paquier
On Thu, Nov 23, 2017 at 1:28 AM, Alexander Pyhalov wrote: > On 11/22/17 07:24 PM, Magnus Hagander wrote: >> What is your postgres version, and what's the "version history" of >> upgrades >> from it (talking pg_upgrade upgrades, not dump/reload upgrades). This >> might >> be fallout from old bugs t

Re: duplicate primary key

2017-11-22 Thread Alexander Pyhalov
On 11/22/17 07:24 PM, Magnus Hagander wrote: What is your postgres version, and what's the "version history" of upgrades from it (talking pg_upgrade upgrades, not dump/reload upgrades). This might be fallout from old bugs thaat have been known to cause this type of problem. It's PostgreSQL 9.

Re: duplicate primary key

2017-11-22 Thread Magnus Hagander
On Wed, Nov 22, 2017 at 12:05 PM, Alexander Pyhalov wrote: > Hello. > > I'm a bit shocked. During import/export of our database we've found a > duplicate primary key. > > # \d player > > Table "public.player" >Column |Type | > Modifiers > ---

Re: duplicate primary key

2017-11-22 Thread Thomas Markus
Am 22.11.17 um 12:05 schrieb Alexander Pyhalov: Hello. I'm a bit shocked. During import/export of our database we've found a duplicate primary key. # \d player Table "public.player"    Column   |    Type |     Modifiers --