Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 28E409FAE4E for ; Thu, 28 Sep 2006 12:26:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 98543-05 for ; Thu, 28 Sep 2006 12:26:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc3-s38.bay0.hotmail.com (bay0-omc3-s38.bay0.hotmail.com [65.54.246.238]) by postgresql.org (Postfix) with ESMTP id 152B49F9F96 for ; Thu, 28 Sep 2006 12:26:40 -0300 (ADT) Received: from hotmail.com ([64.4.26.16]) by bay0-omc3-s38.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 28 Sep 2006 08:26:39 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 28 Sep 2006 08:26:39 -0700 Message-ID: Received: from 64.4.26.200 by by112fd.bay112.hotmail.msn.com with HTTP; Thu, 28 Sep 2006 15:26:36 GMT X-Originating-IP: [82.236.140.42] X-Originating-Email: [e1lauren@hotmail.com] X-Sender: e1lauren@hotmail.com In-Reply-To: <1d219a6f0609280810j5e156f33uaafbb37c17ee5d5d@mail.gmail.com> From: "Mathias Laurent" To: pgsql-admin@postgresql.org Subject: SELECT FOR UPDATE NOWAIT Date: Thu, 28 Sep 2006 15:26:36 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 28 Sep 2006 15:26:39.0470 (UTC) FILETIME=[7E4F98E0:01C6E312] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.904 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS, SUBJ_ALL_CAPS X-Spam-Level: ** X-Archive-Number: 200609/336 X-Sequence-Number: 23250 If I do : Session 1: decibel=# begin; BEGIN decibel=# select * from i where i=1 for update nowait; i --- 1 (1 row) decibel=# begin; BEGIN decibel=# select * from i where i=2 for update nowait; i --- 2 (1 row) Session 2 : decibel=# select * from i where i=1 for update nowait; ERROR: could not obtain lock on row in relation "i" decibel=# select * from i where i=3 for update nowait; ERROR: current transaction is aborted, commands ignored until end of transaction block decibel=# ==> Why ? :'( Why i can't do any "Select for update" (current transaction aborted) after having receive a not obtain lock ??? Thank you for your answer ! _________________________________________________________________ Windows Live Messenger sur i-mode™ : dialoguez avec vos amis depuis votre mobile comme sur PC ! http://mobile.live.fr/messenger/bouygues/