Re: How to discard partially retrieved result set with the C API?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: How to discard partially retrieved result set with the C API?
Дата
Msg-id CAFj8pRDDwTFX4Vmn+526yAB0fvp2V0KVRNGSzqf2n+Z0TyATPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to discard partially retrieved result set with the C API?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Список pgsql-general
Дерево обсуждения



2014-02-18 11:53 GMT+01:00 Dmitriy Igrishin <dmitigr@gmail.com>:


2014-02-18 13:44 GMT+04:00 邓尧 <torshie@gmail.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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: How to discard partially retrieved result set with the C API?
Следующее
От: Herouth Maoz
Дата:
Сообщение: Re: How do I track down a possible locking problem?