Locking certain rows in a transaction

[peter groh]

Hi,

i'm currently experimenting with nested sets. To insert a new node,, I need 1 SELECT, 2 UPDATE and 1 INSERT statement.
Of course all of this wii be packed into a transaction, because the table could get corrupted if not all of the mentioned queries are executed.

Now here's the question: I need to lock certain rows, so that no other client can read or write that rows (I want those clients to wait until the transaction is commited or rolled back). I don't want to lock the entire table, since that would block to many clients, which never intended to read the critical rows.

Please don't simply post a link to the documentation. I tried to read it, but I didn't find the solution.

Example would be nice.

Greets, peter



Edited 1 time(s). Last edit at 08/09/2008 06:06AM by peter groh.