Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id BD9D21336971
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  4 Oct 2010 16:07:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 87560-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  4 Oct 2010 19:07:07 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nm24.bullet.mail.ne1.yahoo.com (nm24.bullet.mail.ne1.yahoo.com
	[98.138.90.87])
	by mail.postgresql.org (Postfix) with SMTP id 2EA8A133655C
	for <pgsql-admin@postgresql.org>; Mon,  4 Oct 2010 16:07:07 -0300 (ADT)
Received: from [98.138.90.55] by nm24.bullet.mail.ne1.yahoo.com with NNFMP;
	04 Oct 2010 19:07:06 -0000
Received: from [98.138.87.8] by tm8.bullet.mail.ne1.yahoo.com with NNFMP;
	04 Oct 2010 19:07:06 -0000
Received: from [127.0.0.1] by omp1008.mail.ne1.yahoo.com with NNFMP;
	04 Oct 2010 19:07:05 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 911906.34826.bm@omp1008.mail.ne1.yahoo.com
Received: (qmail 20116 invoked by uid 60001); 4 Oct 2010 19:07:05 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1286219225; bh=UdO9BidbY9K9t49ZNmZsHTdPgNfE2w+z2/rMNzPLHrc=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=hxNp8E5szKHryuOveTMtB1CAG9iEbAWvmPt0z+RzoaGlGQ/21udyCB4zCTm8mmghhk0jVEJlN6fZb1EWSsp8gySIiq/O4T4ZRVHLA8jUbjvYcNLWRccHFCquELGpugLAyG6kiuFwCYPXEyzJZXaOxX6Gl74uWM7sptipdKJsCx0=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=FZmL/x03HD/80kYgYMF0qM3HSE0tNSscLtGuVA1CfdqqxjBG+LPQJ0LXZvD1sLVsDgEp7cHVVaU1/bA27yjwL0NYlhl73bQs18b+b9jLPnGOBjlFRAnlcX0jAzjGZd/cvR3pcUXSYY7sTLDtzyRTEYxHkmBYg3/tDop/ZB+UxxY=;
Message-ID: <812668.19871.qm@web120007.mail.ne1.yahoo.com>
X-YMail-OSG: _ngoyD4VM1m40u14ldO7xf_fH8BGxsUlcx_oqaKXsXmYy28
	l.TJZ.wkCi1ObEwH7_.xCUfiyYDNO5MxlpUscfzhQflF1SYjHXj5C_ff5cia
	_l825vfcGY7siSHNW3sjdeM6Ih23jR3m1CzIo28YlrxpiTm7WFguV5hVwGYO
	FLCLMpAg_B6EoBBvOKfX_0O_xClzj08TuwdpLLg--
Received: from [68.36.212.155] by web120007.mail.ne1.yahoo.com via HTTP;
	Mon, 04 Oct 2010 12:07:05 PDT
X-Mailer: YahooMailRC/497 YahooMailWebService/0.8.106.282862
Date: Mon, 4 Oct 2010 12:07:05 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Subject: ECPG: AUTOCOMMIT and CURSORs
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1394981166-1286219225=:19871"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.138 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.347,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: **
X-Archive-Number: 201010/26
X-Sequence-Number: 35767

--0-1394981166-1286219225=:19871
Content-Type: text/plain; charset=us-ascii

I am seeing some funny behavior on using both:
EXEC SQL SET AUTOCOMMIT TO ON;
and
CURSORS (EXEC SQL DECLARE ............., EXEC SQL FETCH NEXT FROM .............)

On autocommit on (either through above method or precompiling with -t option), 
the cursor does not return any rows. On disabling autocommit, I get the required 
number of rows from the cursor.

Any idea what could be going on ? 

Thanks!
AJ


      
--0-1394981166-1286219225=:19871
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div>I am seeing some funny behavior on using both:</div><div>EXEC SQL SET AUTOCOMMIT TO ON;</div><div>and</div><div>CURSORS (EXEC SQL DECLARE ............., EXEC SQL FETCH NEXT FROM .............)</div><div><br></div><div>On autocommit on (either through above method or precompiling with -t option), the cursor does not return any rows. On disabling autocommit, I get the required number of rows from the cursor.</div><div><br></div><div>Any idea what could be going on ?&nbsp;</div><div><br></div><div>Thanks!</div><div>AJ</div><div style="position:fixed"></div>


</div><br>

      </body></html>
--0-1394981166-1286219225=:19871--