There were other JDBC clients but they never
lock any tables. They all used transactions with the serializable isolation
level.
If you have concurrent access and some isolation you have locking.
If two inserts/updates try to change the same data (even via
triggers/rules) you get a failed
Hi,
A few days ago an insertion operation issued by a JDBC client that was
blocked by
postgreSQL. I could verify that by issuing the operation using psql. My
question is,
what could be causing this? There were other JDBC clients but they never
lock any
tables. They all used transactions with