Postgres Pro
Downloads
Home   >   mailing lists

Re: How to discard partially retrieved result set with the C API? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: How to discard partially retrieved result set with the C API?
Date
Msg-id CAFj8pRDDwTFX4Vmn+526yAB0fvp2V0KVRNGSzqf2n+Z0TyATPg@mail.gmail.com
Whole thread Raw
In response to Re: How to discard partially retrieved result set with the C API?  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
Tree view



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 by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: How to discard partially retrieved result set with the C API?
Next
From: Herouth Maoz
Date:
Subject: Re: How do I track down a possible locking problem?