Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WKqxM-0002qK-PW for pgsql-sql@arkaria.postgresql.org; Tue, 04 Mar 2014 15:08:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WKqxL-00006L-Tl for pgsql-sql@arkaria.postgresql.org; Tue, 04 Mar 2014 15:08:31 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WKqxJ-0008Tg-4y; Tue, 04 Mar 2014 15:08:29 +0000 Received: from new1-smtp.messagingengine.com ([66.111.4.221]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WKqxG-0000fD-JL; Tue, 04 Mar 2014 15:08:28 +0000 Received: from compute1.internal (compute1.nyi.mail.srv.osa [10.202.2.41]) by gateway1.nyi.mail.srv.osa (Postfix) with ESMTP id 5DF8358A; Tue, 4 Mar 2014 10:08:23 -0500 (EST) Received: from frontend2 ([10.202.2.161]) by compute1.internal (MEProxy); Tue, 04 Mar 2014 10:08:23 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h= message-id:date:from:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; s=mesmtp; bh=ufpAKdeGAWEe/YPk0XVvITxO1z0=; b=bk79C24J+jPf0cejeZVFMbRqh9eZ kHzuUp/KB0olX/yOi0ajkfPJF3Fkp0BNE9aCd49QsAxuZojzR8vjrPsLAgPsagOU /eH0A3GavcFwSdfSzRYqX7UIbN1q+Nci0zh0nqeqDksw3qe4JWxCuvh3sKbkn53T 2g0D3ZJy59Iq/zk= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=message-id:date:from:mime-version:to :subject:references:in-reply-to:content-type :content-transfer-encoding; s=smtpout; bh=ufpAKdeGAWEe/YPk0XVvIT xO1z0=; b=TGZrsvvYw1Rawgk1Etr/CogpwbZi3+E6TvePLkNRbMuHZllG7pUKZh QDZ0ZbnPTozF00f3N60ud5O2xv6Bu/kUjwX4jMIm7ctdRT+B6nMKf8s3lSmRB4OT WCeK/YHQVJQeatjrZ4k0tNN/jaarzReXiarDSOMiL4F2Atovt6CVM= X-Sasl-enc: tDBLPpIO54c/r68/nMvyr3P8E1VXDJkQ4rCZw7+/pXR8 1393945702 Received: from panda.site (unknown [97.113.11.16]) by mail.messagingengine.com (Postfix) with ESMTPA id 8D8F96802C2; Tue, 4 Mar 2014 10:08:22 -0500 (EST) Message-ID: <5315EC65.6060601@aklaver.com> Date: Tue, 04 Mar 2014 07:08:21 -0800 From: Adrian Klaver User-Agent: Mozilla/5.0 (X11; Linux i686; rv:24.0) Gecko/20100101 Thunderbird/24.3.0 MIME-Version: 1.0 To: ALMA TAHIR , "pgsql-sql-owner@postgresql.org" , "pgsql-sql@postgresql.org" , Tom Lane Subject: Re: pgsql-sq-owner References: <1393502935.39715.YahooMailNeo@web192706.mail.sg3.yahoo.com> <1393911321.81761.YahooMailNeo@web192702.mail.sg3.yahoo.com> In-Reply-To: <1393911321.81761.YahooMailNeo@web192702.mail.sg3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On 03/03/2014 09:35 PM, ALMA TAHIR wrote: > Hi, > > I am using below code in multi threaded environment, but when multiple > threads are accessing then i get : "org.postgresql.util.PSQLException: > ERROR: tuple concurrently updated" exception. But my concern is I need > to use it in multi threaded env, for the same reason I am using FOR > UPDATE with cursor. Then where is the issue??? Am I missing > something????? Please help me with the same.... So I assume this is a second attempt at your previous thread ' Function Issue'. I will respond on the previous thread to keep it intact. > > -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql