DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type;
 b=wmzLdyMmKSUwV+nJBwc5gyyYpmGOTuOSXAbwn0afsFsQ6VhunDLGjuLytSdqnPulCmtZEJxHn7h6q2AakQpq0Hw3ujKLLzrLxMLbqzwrcHc3hX6aAwCFP7mS++3FPnxhK/KectDqoUGGIFTDFzXM4CT7w8T/Ko5ExdA5BgpD3nE=;
References: <1393503792.47079.YahooMailNeo@web192706.mail.sg3.yahoo.com>
 <30402.1393511579@sss.pgh.pa.us>
Message-ID: <1393593190.2407.YahooMailNeo@web192706.mail.sg3.yahoo.com>
Date: Fri, 28 Feb 2014 21:13:10 +0800 (SGT)
From: ALMA TAHIR <almaheena2003@yahoo.co.in>
Reply-To: ALMA TAHIR <almaheena2003@yahoo.co.in>
Subject: Re: Function Issue
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
In-Reply-To: <30402.1393511579@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="-897285659-318668661-1393593190=:2407"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

---897285659-318668661-1393593190=:2407
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

hi,=0Athankyou for suggestions, its working now. I ma retrieving the ids in=
 an int[] and then using one more cursor to read and return using the int[]=
. =0A=0A=0A=0A=0A=0AOn Thursday, 27 February 2014 8:04 PM, Tom Lane <tgl@ss=
s.pgh.pa.us> wrote:=0A =0AALMA TAHIR <almaheena2003@yahoo.co.in> writes:=0A=
> I want to open a ref cursor with select for update and then update=0A> th=
e records and get the ref cursor in response back in java.=0A=0AYour functi=
on has already sucked all the rows out of the cursor before=0Ait returns it=
, so it's not surprising that further reads from the cursor=0Aproduce nothi=
ng.=0A=0AYou could try rewinding the cursor (see MOVE) but I'm not sure tha=
t will=0Ahelp in this case, since the function has carefully ensured that n=
one of=0Athe rows pass the cursor query's WHERE condition anymore.=A0 I thi=
nk that=0Asince the cursor used SELECT FOR UPDATE, it will not return the u=
pdated=0Arows even after rewinding.=A0 (I could be wrong though, so it's wo=
rth=0A=0Atrying.)=0A=0AI think you need to rethink what you're doing.=A0 Th=
is seems like a fairly=0Asilly application design: why not do all the proce=
ssing you need on these=0Arows in one place?=A0 Or at the very least, don't=
 use one cursor to serve=0Atwo masters.=A0 Possibly you could have the func=
tion return the rows itself=0Ainstead of passing back a refcursor.=0A=0A=A0=
=A0=A0 =A0=A0=A0 =A0=A0=A0 regards, tom lane=0A=0A=0A-- =0ASent via pgsql-s=
ql mailing list (pgsql-sql@postgresql.org)=0ATo make changes to your subscr=
iption:=0Ahttp://www.postgresql.org/mailpref/pgsql-sql
---897285659-318668661-1393593190=:2407
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt">hi,<br>thankyou for s=
uggestions, its working now. I ma retrieving the ids in an int[] and then u=
sing one more cursor to read and return using the int[]. <br><div><span><br=
></span></div><div style=3D"display: block;" class=3D"yahoo_quoted"> <br> <=
br> <div style=3D"font-family: times new roman, new york, times, serif; fon=
t-size: 12pt;"> <div style=3D"font-family: times new roman, new york, times=
, serif; font-size: 12pt;"> <div dir=3D"ltr"> <font face=3D"Arial" size=3D"=
2"> On Thursday, 27 February 2014 8:04 PM, Tom Lane &lt;tgl@sss.pgh.pa.us&g=
t; wrote:<br> </font> </div>  <div class=3D"y_msg_container">ALMA TAHIR &lt=
;<a shape=3D"rect" ymailto=3D"mailto:almaheena2003@yahoo.co.in" href=3D"mai=
lto:almaheena2003@yahoo.co.in">almaheena2003@yahoo.co.in</a>&gt; writes:<br=
 clear=3D"none">&gt; I want to open a ref cursor with select for update and=
 then update<br
 clear=3D"none">&gt; the records and get the ref cursor in response back in=
 java.<br clear=3D"none"><br clear=3D"none">Your function has already sucke=
d all the rows out of the cursor before<br clear=3D"none">it returns it, so=
 it's not surprising that further reads from the cursor<br clear=3D"none">p=
roduce nothing.<br clear=3D"none"><br clear=3D"none">You could try rewindin=
g the cursor (see MOVE) but I'm not sure that will<br clear=3D"none">help i=
n this case, since the function has carefully ensured that none of<br clear=
=3D"none">the rows pass the cursor query's WHERE condition anymore.&nbsp; I=
 think that<br clear=3D"none">since the cursor used SELECT FOR UPDATE, it w=
ill not return the updated<br clear=3D"none">rows even after rewinding.&nbs=
p; (I could be wrong though, so it's worth<div class=3D"yqt6629385464" id=
=3D"yqtfd36909"><br clear=3D"none">trying.)</div><br clear=3D"none"><br cle=
ar=3D"none">I think you need to rethink what you're doing.&nbsp; This seems=
 like a fairly<br
 clear=3D"none">silly application design: why not do all the processing you=
 need on these<br clear=3D"none">rows in one place?&nbsp; Or at the very le=
ast, don't use one cursor to serve<br clear=3D"none">two masters.&nbsp; Pos=
sibly you could have the function return the rows itself<br clear=3D"none">=
instead of passing back a refcursor.<br clear=3D"none"><br clear=3D"none">&=
nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; regards, tom lane<b=
r clear=3D"none"><br clear=3D"none"><br clear=3D"none">-- <br clear=3D"none=
">Sent via pgsql-sql mailing list (<a shape=3D"rect" ymailto=3D"mailto:pgsq=
l-sql@postgresql.org" href=3D"mailto:pgsql-sql@postgresql.org">pgsql-sql@po=
stgresql.org</a>)<br clear=3D"none">To make changes to your subscription:<b=
r clear=3D"none"><a shape=3D"rect" href=3D"http://www.postgresql.org/mailpr=
ef/pgsql-sql" target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-sq=
l</a><div class=3D"yqt6629385464" id=3D"yqtfd25738"><br clear=3D"none"></di=
v><br><br></div>  </div> </div>=20
 </div> </div></body></html>
---897285659-318668661-1393593190=:2407--