Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1BB8A9FB58C for ; Tue, 3 Apr 2007 10:57:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 30326-02-9 for ; Tue, 3 Apr 2007 10:57:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 2D6139FBA25 for ; Tue, 3 Apr 2007 10:57:44 -0300 (ADT) Received: from hawking.credativ.lan (unknown [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 49275D764B; Tue, 3 Apr 2007 15:57:39 +0200 (CEST) From: Peter Eisentraut To: pgsql-sql@postgresql.org, Carlos Santos Subject: Re: LOCK command inside a TRANSACTION Date: Tue, 3 Apr 2007 15:57:33 +0200 User-Agent: KMail/1.9.5 References: <141386.39515.qm@web57105.mail.re3.yahoo.com> In-Reply-To: <141386.39515.qm@web57105.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200704031557.33680.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/30 X-Sequence-Number: 28030 Am Dienstag, 3. April 2007 14:48 schrieb Carlos Santos: > - if an user query a select on a table, the rows of the table in the result > of this select can not be updated or deleted by another user until this one > update, delete or discard the changes on those rows. Sounds like SELECT FOR UPDATE. -- Peter Eisentraut http://developer.postgresql.org/~petere/