""Marian Naghen"" <[EMAIL PROTECTED]> wrote > 1. if a user set a write lock and then, for some reason (bad > connections, app chashes, etc), disconect from server without releasing, > what happened with the lock ? It will be still holding ?
When the connection is lost, server will release all its resources, including locks. > 2. there is a way to set/obtain informations about the user who sets a > lock ? Check out pg_stat_get_backend_userid(integer backendid) function. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
