Search Postgresql Archives

Re: Possible causes for "tuple concurrently updated" error

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

 



Pinpoint updates of the form

UPDATE $TABLE set field1=$FOO, field2=$BAR ... WHERE pk=$ID
  • All fields are specified
  • Table has no foreign keys (but does have a unmber of indexes)
  • executed as a prepared statement with bind params & data for multiple rows provided


On Thu, May 5, 2016 at 8:13 AM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> wrote:
Jacob Scott wrote:
> Arg, should have included this in my initial email :-(
>
> 9.3.11

OK.  So what are the updates doing?  Are there any FKs involved?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux