dbTalk Databases Forums  

Record Locked by?

comp.databases.postgresql.interfaces comp.databases.postgresql.interfaces


Discuss Record Locked by? in the comp.databases.postgresql.interfaces forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hal Davison
 
Posts: n/a

Default Record Locked by? - 07-21-2003 , 02:47 PM






Is there a method to determine if a record is locked and by whom?

I know that if we issue:

select '....' from (Table) FOR UPDATE ....

Will lock a record if the record is not locked by someone else but if it IS
locked how do we determine WHO has it locked?

--
Hal Davison
Davison Consulting



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.