On Fri, Dec 21, 2012 at 11:47 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
zelaine@amazon.com writes: > The following bug has been logged on the website: > Bug reference: 7766 > Logged by: Zelaine Fong > Email address: zelaine@amazon.com > PostgreSQL version: 8.4.0 > Operating system: Linux > Description:
> The updateCount field in the ResultHandler interface in Java is defined as > an int rather than long. Therefore, if you prepare and execute an update, > delete, or insert statement that affects more than 2^32 rows, you will get > the following exception:
> Unable to interpret the update count in command completion tag
Forwarding this to pgsql-jdbc list. FWIW, guys, the backend currently thinks that execution counts are unsigned ints. So I surmise that the problematic update count was actually between 2^31 and 2^32. We might get around to changing it to unsigned long someday ...