DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=4+MuQBzPFSngptBpJIWpd2f4+fz76X99aAUYbMg2412fKmxO4eWXM7EmJuQiCMRaNvBpNocATwraKJ2sD69PaLNBgFjlovPmrN8JRQ1Fa6OfF1o4CcMSCnJogjrAi7oLipeinn03xu+ycwx3gJ/vf07F244BWtlc4JQ3//AL29o=;
Message-ID: <765296.62990.qm@web120013.mail.ne1.yahoo.com>
References: <812668.19871.qm@web120007.mail.ne1.yahoo.com>
	<4CA9FEBE02000025000364B4@gw.wicourts.gov>
Date: Tue, 5 Oct 2010 10:51:18 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Subject: Re: ECPG: AUTOCOMMIT and CURSORs
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-admin@postgresql.org
In-Reply-To: <4CA9FEBE02000025000364B4@gw.wicourts.gov>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-143369836-1286301078=:62990"

--0-143369836-1286301078=:62990
Content-Type: text/plain; charset=us-ascii

That would explain it. I was neither in a transaction nor did any explicit HOLD. 
Thanks Kevin.


________________________________
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org; A J <s5aly@yahoo.com>
Sent: Mon, October 4, 2010 5:20:14 PM
Subject: Re: [ADMIN] ECPG: AUTOCOMMIT and CURSORs

A J <s5aly@yahoo.com> wrote:

> 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 ? 

Are you inside of a transaction?  How does the WITH or WITHOUT HOLD
function in ECPG?  From the manual:

http://www.postgresql.org/docs/current/interactive/sql-declare.html

"WITHOUT HOLD specifies that the cursor cannot be used outside of
the transaction that created it. If neither WITHOUT HOLD nor WITH
HOLD is specified, WITHOUT HOLD is the default."

-Kevin


--0-143369836-1286301078=:62990
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>That would explain it. I was neither in a transaction nor did any explicit HOLD. Thanks Kevin.</div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><br><div style="font-family:arial, helvetica, sans-serif;font-size:13px"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Kevin Grittner &lt;Kevin.Grittner@wicourts.gov&gt;<br><b><span style="font-weight: bold;">To:</span></b> pgsql-admin@postgresql.org; A J &lt;s5aly@yahoo.com&gt;<br><b><span style="font-weight: bold;">Sent:</span></b> Mon, October 4, 2010 5:20:14 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [ADMIN] ECPG: AUTOCOMMIT and CURSORs<br></font><br>
A J &lt;<a ymailto="mailto:s5aly@yahoo.com" href="mailto:s5aly@yahoo.com">s5aly@yahoo.com</a>&gt; wrote:<br> <br>&gt; I am seeing some funny behavior on using both:<br>&gt; EXEC SQL SET AUTOCOMMIT TO ON;<br>&gt; and<br>&gt; CURSORS (EXEC SQL DECLARE ............., EXEC SQL FETCH NEXT FROM <br>&gt; .............)<br>&gt; <br>&gt; On autocommit on (either through above method or precompiling with<br>&gt; -t option), <br>&gt; the cursor does not return any rows. On disabling autocommit, I<br>&gt; get the required number of rows from the cursor.<br>&gt; <br>&gt; Any idea what could be going on ? <br> <br>Are you inside of a transaction?&nbsp; How does the WITH or WITHOUT HOLD<br>function in ECPG?&nbsp; From the manual:<br> <br><span><a target="_blank" href="http://www.postgresql.org/docs/current/interactive/sql-declare.html">http://www.postgresql.org/docs/current/interactive/sql-declare.html</a></span><br> <br>"WITHOUT HOLD specifies that the cursor cannot
 be used outside of<br>the transaction that created it. If neither WITHOUT HOLD nor WITH<br>HOLD is specified, WITHOUT HOLD is the default."<br> <br>-Kevin<br></div></div><div style="position:fixed"></div>


</div><br>

      </body></html>
--0-143369836-1286301078=:62990--