Hi,
I'm seeing an "EXCLUSIVE" lock being taken on a table even though the
documentation says that "This lock mode is not automatically acquired on
user tables by any PostgreSQL command."
My SQL is
UPDATE users SET online = $1 where username = $2
username is the PK on the users table.
Other lock
Version of postgres is 8.2.4.
Maybe it will help to give more b/g on how I'm identifying the problem?
The way this materializes as a real issue surrounds transactions left idle.
There is a bug in our app that we haven't tracked down yet where on occasion
we end up with connections marked " in tra
