pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Andrus <kobruleht2@hot.ee>
To: pgsql-general@postgresql.org
Subject: Re: Duplicate key error
Date: Thu, 4 Mar 2021 08:42:16 -0800
Message-ID: <6cdec299-a677-03c4-2c8e-36560e052c9e@aklaver.com> (raw)
In-Reply-To: <6a9dcf88-7b28-3b8f-0a1a-8a163f45a2a8@hot.ee>
References: <a8656d4f-d692-ffae-077e-304f348e25bf@hot.ee>
	<5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>
	<97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee>
	<c22a9fa0-9f3a-8b68-c1d4-a430cf7286bc@aklaver.com>
	<abc069b9-5e92-b461-f215-68ad67a533b6@hot.ee>
	<d669cc09-aa93-cdf3-5030-37318d2a9001@aklaver.com>
	<6a9dcf88-7b28-3b8f-0a1a-8a163f45a2a8@hot.ee>

On 3/3/21 10:14 PM, Andrus wrote:
> Hi!
>> says something else is inserting/updating using that key value. So 
>> obviously your script is not catching all the conflicts.
> 
>  > At this point your best bet is to monitor the Postgres log and see 
> what else is happening at the time of the error. I'm guessing you will 
> find another process working on that table.
> 
> It looks like other process has added same row during trancaction.
> 
> How to change script so that it works starting at Postgres 9.0 and does 
> not cause error in this case ?

Since we have not actually seen the entire script nor have any idea what 
the other process is, there is no way to answer this.

> 
> Andrus.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com





view thread (22+ messages)  latest in thread

Message-ID: <6cdec299-a677-03c4-2c8e-36560e052c9e@aklaver.com>
Permalink:  ../6cdec299-a677-03c4-2c8e-36560e052c9e@aklaver.com/
Also on:    postgresql.org/message-id/6cdec299-a677-03c4-2c8e-36560e052c9e@aklaver.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: adrian.klaver@aklaver.com, kobruleht2@hot.ee
  Subject: Re: Duplicate key error
  In-Reply-To: <6cdec299-a677-03c4-2c8e-36560e052c9e@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox