Locks only affects the lines in the table selected in the sql query, right?
-----Mensagem original-----
De: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] Em nome de Bruno Wolff III
Enviada: quinta-feira, 4 de Maio de 2006 20:21
Para: Christian Hofmann
Cc: pgsql-novice@postgresql.org
Assunto: Re: [NOVICE] SELECT FOR UPDATE - release lock?
On Thu, May 04, 2006 at 22:08:16 +0200,
Christian Hofmann <christian.hofmann@gmx.de> wrote:
> Hello,
>
> for some tables I am using a "select a,b,c from mytable where x='abc' FOR
> UPDATE" query to prevent other servers also modify this data while I am
> reading the data and decide to modify the data.
>
> Now sometimes I don't want to make an update. Is there a way to release
the
> lock. Or is the lock released by simply call commit?
Locks are released when transactions end.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings