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@xxxxxxxxxxx
