Re: Locking tables

Markus Bertheau wrote:

>В Пнд, 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?
>
>
>
Yes, unless you have a unique constraint (or primary key) on that table
for the id (if you do, then attempts to insert another row with the same
id will fail)...

Dima

P.S. Your name doesn't look Russian to me... How come you seem to be
using a Russian email client? :-)