Search Postgresql Archives

Re: Duplicate key error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux