Thread: user_write_lock_oid questions

user_write_lock_oid questions

From

"Marian Naghen"

Date:

02 December 2005, 09:03:38

I'm new to PostgreSQL and I'm a litle confused.

I have 2 questions about using user_write_lock functions:

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 ?

2. there is a way to set/obtain informations about the user who sets a lock ?

thanks.

Re: user_write_lock_oid questions

From

"Qingqing Zhou"

Date:

03 December 2005, 05:03:42

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