Subject Re: [firebird-support] Pessimistic locking
Author Helen Borrie
At 02:44 PM 22/09/2003 +0000, you wrote:
>I have to lock a set of tables, do some stuff in my app, and then
>unlock the tables.
>How can I do this with firebird?

Can you explain a bit more about what you want to achieve by "locking a table"?

>With SAP, I could just issue a LOCK on a table...

With Firebird, you have various levels of transaction isolation with
various effects what other transactions can do/see. Locking is at
row-level and can be at set-level.

For a total blackout of tables to other transactions, you can get a
table-level lock using a RESERVING clause in the transaction spec, but it's
extremely rare to need that.