Skip site navigation (1) Skip section navigation (2)

Re: setFetchSize

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: setFetchSize
Date: 2011-10-26 06:45:56
Message-ID: CA+0W9LOF3VN72OhmsJdQyT0AWyXUxUcBBJRgDpzOK=zeYSX9xg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 26 October 2011 19:37, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 10/25/11 11:09 PM, fschmidt wrote:
>>
>> Okay I see the documentation saying portals die at the end of a
>> transaction,
>> here:
>
> I'm surprised you can make /any/ other queries on that connection with an
> unfinished portal.
>
> I'm pretty sure if I needed to have an open transfer while executing another
> transaction, I'd use more than one connection.

You probably want to reread the protocol docs. Portals are very
similar to SQL cursors and while the portal does indeed monopolize the
connection while it is executing, you don't have to fetch all the
results from a portal in one go.

Oliver

In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2011-10-26 08:28:35
Subject: Re: setFetchSize
Previous:From: John R PierceDate: 2011-10-26 06:37:03
Subject: Re: setFetchSize

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group