Re: Locking tables - Mailing list pgsql-novice

From Markus Bertheau
Subject Re: Locking tables
Date
Msg-id 1058909937.5502.4.camel@saphir
Whole thread Raw
In response to Re: Locking tables  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: Locking tables
List pgsql-novice
В Пнд, 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.

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Encrypted data.
Next
From: Dmitry Tkach
Date:
Subject: Re: Locking tables