Postgres Pro
Downloads
Home   >   mailing lists

user_write_lock_oid questions - Mailing list pgsql-general

From Marian Naghen
Subject user_write_lock_oid questions
Date
Msg-id 001a01c5f739$90aeab90$f503a8c0@lapcontr01
Whole thread Raw
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: postmaster / resolv.conf / dns problem
Next
From: "Francesco Formenti - TVBLOB S.r.l."
Date:
Subject: deadlock on the same relation