""Marian Naghen"" <naghen@xxxxxxx> 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
