Skip site navigation (1) Skip section navigation (2)

Get details of user locking a record?

From: Rob Northcott <Rob(at)teamsystems(dot)co(dot)uk>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Get details of user locking a record?
Date: 2010-05-12 14:22:58
Message-ID: 4300547FCC2E2A4EA97985D577953D2E8E45E4ADF8@SERVER.team.local (view raw or flat)
Thread:
Lists: pgsql-novice
Hello list,

I'm pretty new to SQL servers, so this may be a silly question, but here goes anyway...

When a user tries to edit a record (SELECT * FROM mytable WHERE key = 'mykey' FOR UPDATE NOWAIT)  and it is locked by another user, I can trap the error and tell the user it is locked.  No problems there.  But is it possible to find out what other user (name or ip address?) is doing the locking?  I've done lots of web searching and it seems like it's considered a bad idea to lock records in database applications - but I don't want my users to spend ages editing, say, a customer's address or notes, only to be told they can't save the changes because somebody else has edited it in the meantime.

Is there an easy way (or any way for that matter) to find out who owns the lock on a specific record or a table?

Rob Northcott
Programmer, Team Systems Ltd.


Attachment: AVG certification.txt
Description: text/plain (93 bytes)

pgsql-novice by date

Next:From: Tony DayDate: 2010-05-12 20:05:16
Subject: Re: Get details of user locking a record?
Previous:From: Atif JungDate: 2010-05-12 13:31:09
Subject: Interrupt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group