X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 5AE0D11F66FC for ; Wed, 12 Apr 2006 22:57:52 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.693 X-Spam-Level: X-Spam-Status: No, score=0.693 required=5 tests=[BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0, SPF_SOFTFAIL=1.384] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id QDfzMtF8k2uR for ; Wed, 12 Apr 2006 22:57:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A59FA11F66C4 for ; Wed, 12 Apr 2006 22:57:49 -0300 (ADT) Received: from hotmail.com (bay112-f31.bay112.hotmail.com [64.4.26.41]) by svr4.postgresql.org (Postfix) with ESMTP id 9E8105AF947 for ; Thu, 13 Apr 2006 01:57:52 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 12 Apr 2006 18:57:49 -0700 Message-ID: Received: from 64.4.26.200 by by112fd.bay112.hotmail.msn.com with HTTP; Thu, 13 Apr 2006 01:57:47 GMT X-Originating-IP: [82.236.140.42] X-Originating-Email: [e1lauren@hotmail.com] X-Sender: e1lauren@hotmail.com From: "Mathias Laurent" To: pgsql-admin@postgresql.org Subject: Problem with SELECT FOR UPDATE NOWAIT Date: Thu, 13 Apr 2006 01:57:47 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 13 Apr 2006 01:57:49.0300 (UTC) FILETIME=[AAAD5340:01C65E9D] X-Archive-Number: 200604/115 X-Sequence-Number: 21284 Hello, Veiled I have a small problem which I have solved in a way not very clean, I would thus like to have your opinion. When I made with the process 1 : Select * FROM myTable WHERE num=3 FOR UPDATE NOWAIT And that I remade it with a process 2 before having do one "Commit" It blocked me (until there normal) But once that I free by doing one "Commit" with process 1 All the table remains to block for process 2... To have access it, it is necessary that I do one "Commit" with the processus2 !! It's very strange... Thank you, Mathias Laurent _________________________________________________________________ Windows Live Mail : découvrez et testez la version bêta ! http://www.ideas.live.com/