On 2013-06-11 19:20:57 +0300, Heikki Linnakangas wrote:
> On 11.06.2013 19:04, Joshua Berry wrote:
> >Hiroshi Inoue has developed the attached patch to correct the issue that
> >was reported. More of the dialogue can be found in the pgsql-odbc list.
>
> I tried to follow that thread over at pgsql-odbc, but couldn't quite
> understand what the problem is. Did you have a test program to reproduce it?
> Or failing that, what is the sequence of protocol messages that causes the
> problem?
I'd guess creating a SQL level WITH HOLD cursor and then fetching that
via the extended protocol, outside the transaction, should do the trick.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services