Re: ECPG, cursors and transactions - Mailing list pgsql-bugs

From Christof Petig
Subject Re: ECPG, cursors and transactions
Date
Msg-id 3A772E92.EEE52EB6@petig-baender.de
Whole thread Raw
In response to ECPG, cursors and transactions  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org wrote:

> Ing. Pavel Janousek (janousek@fonet.cz) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> ECPG, cursors and transactions
>
> Long Description
> When I use ECPG in transactions I got some bad results - I think that this results are bug, but I'm not sure...
(Pglibimplementation?, ECPG implementation?) 
>
> When I use ECPG like this:
> exec sql include sqlca;
> exec sql whenever sqlerror do sqlprint ();
> exec sql connect...
> exec sql declare cur cursor ....
> exec sql open cur;
> exec sql whenever not found do break;
> while (1)
> {
>    exec sql fetch in cur into ...

if

exec sql set autocommit to off;

does not fix your problems then please give more details. (program output etc.) IMHO this should be the default - but
unfortunatelyit isn't ... 

Christof

pgsql-bugs by date:

Previous
From: "Vadim I. Passynkov"
Date:
Subject: Problem with inet/cidr convert functions
Next
From: Tom Lane
Date:
Subject: Re: timestamp/date bug