From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
Cc: | 邓尧 <torshie(at)gmail(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to discard partially retrieved result set with the C API? |
Date: | 2014-02-18 11:28:16 |
Message-ID: | CAFj8pRDDwTFX4Vmn+526yAB0fvp2V0KVRNGSzqf2n+Z0TyATPg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2014-02-18 11:53 GMT+01:00 Dmitriy Igrishin <dmitigr(at)gmail(dot)com>:
>
>
> 2014-02-18 13:44 GMT+04:00 邓尧 <torshie(at)gmail(dot)com>:
>
>> When single row mode is enabled, after retrieving part of the result set,
>> I'm no longer interested in the rest of it (due to error handling or other
>> reasons). How can I discard the result set without repeatedly calling
>> PQgetResult() in such situation ?
>> The result set may be quite large and it's inefficient to call
>> PQgetResult() repeatedly, so it's necessary to do so sometimes.
>>
>> Thanks
>> Yao
>>
> I think you should use PQcancel().
>
is not better to use a cursor for this use case?
Pavel
>
> --
> // Dmitriy.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 2014-02-18 15:13:51 | Re: How do I track down a possible locking problem? |
Previous Message | Dmitriy Igrishin | 2014-02-18 10:53:39 | Re: How to discard partially retrieved result set with the C API? |