Re: Duplicate key error

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate key error
Date: 2021-03-04 06:14:18
Message-ID: 6a9dcf88-7b28-3b8f-0a1a-8a163f45a2a8@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-03-04 06:57:57 Re: Duplicate key error
Previous Message Stacey Haysler 2021-03-04 02:22:01 Re: Code of Conduct: Russian Translation for Review