Re: Resultset holdability

Thanks a lot Oliver, turning off autocommit seems to work :-)

On 22-okt-05, at 01:01, Oliver Jowett wrote:

> Geert Bevin wrote:
>
>
>>> Have you turned autocommit off?
>>>
>> No
>>
>
> The driver won't use portal-based resultsets unless you turn off
> autocommit. This is because it can't create the equivalent of a
> WITH HOLD cursor via protocol-level portals, so any portal created
> will be closed at the end of the creating transaction. With
> autocommit on, the transaction ends immediately after statement
> execution, so using a portal is pointless.
>
> Otherwise it sounds like you meet all the requirements (V3
> protocol, TYPE_FORWARD_ONLY, and fetchsize > 0).
>
> -O
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>

--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage, Belgium
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03

PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net