""Marian Naghen"" <naghen@ratb.ro> 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