Re: Locking tables

В Пнд, 21.07.2003, в 20:03, Dmitry Tkach пишет:

> select * from table where id=1 FOR UPDATE;
>
> ... is what you are looking for - this will put a lock on the rows that
> actually get selected, so that another transaction will not be able to
> modify them until you commit or rollback.

Can new rows be inserted by another connection with id = 1?

--
Markus Bertheau.
Berlin, Berlin.
Germany.