A J <s5aly@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
