| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2011-10-26 08:28:35 | Re: setFetchSize |
| Previous Message | John R Pierce | 2011-10-26 06:37:03 | Re: setFetchSize |