| Subject | Re: [firebird-support] Determining what user has a lock on a table? |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-11-05T01:28:44Z |
At 03:02 AM 5/11/2008, you wrote:
What do you mean by "the database control"?
./heLen
>Hello,What are you talking about here? A pess. lock on a ROW by some means such as a dummy update? or one affecting a whole table such as (shudder) SELECT * FROM ATABLE FOR UPDATE WITH LOCK? or a transaction with a RESERVING clause on that table?
>
>I have an application where the database control holds an immediate lock
>(pessimistic lock) on a row when that row is being edited. Is there a way,
>by reading the system tables, to determine what user has a lock on that
>table at that time?
What do you mean by "the database control"?
./heLen