On Sun, Nov 27, 2016 at 12:54:22PM -0700, Robert Lebel wrote:
> I can't really provide useful additional information, but I just had the same
> issue. An UPDATE with RETURNING statement was consistently failing after
> being called 5 or 6 times. After restarting my app server (which use
> postgres jdbc driver), the update query would work again 5-6 times, then
> fail.
>
> Recreating the table also made the issue disappear (thanks Corey). I tried
> vacuum etc, without success.
It sound like the 5-6 times is related to prepared queries:
http://momjian.us/main/blogs/pgblog/2016.html#June_15_2016
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +