Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA16444;
	Fri, 21 May 1999 09:48:36 -0400 (EDT)
	(envelope-from jose@sferacarta.com)
Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it
 [193.207.10.213])
	by bologna.nettuno.it (8.8.6/8.8.8/NETTuno 3.2) with ESMTP id PAA19337;
	Fri, 21 May 1999 15:48:32 +0200 (MDT)
Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5]
	by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian))
	id 10kqBh-0006GU-00; Fri, 21 May 1999 14:22:13 +0000
Message-ID: <37454FA6.A08F0E68@sferacarta.com>
Date: Fri, 21 May 1999 14:20:54 +0200
From: =?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
X-Mailer: Mozilla 4.5 [it] (Win95; I)
X-Accept-Language: it
MIME-Version: 1.0
To: haj@idianet.net
CC: pgsql-general@postgresql.org, pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] lock row
References: <374543AB.2496CBC2@idianet.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jonathan Davic ha scritto:

> hello
>
> how to lock a row in the table in postgresql ?
>
> thanks

PostgreSQL current version allows only table locks.
If you need row-level locking you have to wait for v6.5 (1 Jun).
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'