Обсуждение: user_write_lock_oid questions

""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