Haifeng Liu wrote: > Can anyone please figure out this ?
This was just answered on the JDBC list by Kris Jurka: Internally the driver splits each batch into sub-batches of 250 to send to the server to reduce the possibility of deadlocking the network connection. When auto-commit is enabled in the driver, the auto-commit setting affects the whole sub-batch of 250 because of how the frontend/backend protocol works. So you are seeing some oddities because of some implementation details and you should not use auto-commit with batch statements. -Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
