Re: [HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-04-11 Thread Karl O. Pinc
On Mon, 11 Apr 2016 19:25:20 +0200 "Shulgin, Oleksandr" wrote: > On Mon, Apr 11, 2016 at 7:15 PM, Karl O. Pinc wrote: > > > Not sure about the part > > > where you call PQsetSingleRowMode() again after seeing > > > PGRES_TUPLES_OK: doesn't look to me like you need or want to do > > > that. You

Re: [HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-04-11 Thread Shulgin, Oleksandr
On Mon, Apr 11, 2016 at 7:15 PM, Karl O. Pinc wrote: > > Should I submit a regression test or something to ensure > that this usage is officially supported? (A grep for > PQsetSingleRowMode in src/test/ finds no hits.) > Can I assume because it's documented it'll continue to work? Pretty much.

Re: [HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-04-11 Thread Karl O. Pinc
On Mon, 11 Apr 2016 15:55:53 +0200 "Shulgin, Oleksandr" wrote: > On Fri, Apr 1, 2016 at 7:53 PM, Karl O. Pinc wrote: > > > > On Fri, 1 Apr 2016 05:57:33 +0200 > > "Shulgin, Oleksandr" wrote: > > > > > On Apr 1, 2016 02:57, "Karl O. Pinc" wrote: > > > > > > > > I assume there are no questio

Re: [HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-04-11 Thread Shulgin, Oleksandr
On Fri, Apr 1, 2016 at 7:53 PM, Karl O. Pinc wrote: > > On Fri, 1 Apr 2016 05:57:33 +0200 > "Shulgin, Oleksandr" wrote: > > > On Apr 1, 2016 02:57, "Karl O. Pinc" wrote: > > > > > > I assume there are no questions about supporting a > > > similar functionality only without PQsetSingleRowMode, >

Re: [HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-04-01 Thread Karl O. Pinc
On Fri, 1 Apr 2016 05:57:33 +0200 "Shulgin, Oleksandr" wrote: > On Apr 1, 2016 02:57, "Karl O. Pinc" wrote: > > > > I assume there are no questions about supporting a > > similar functionality only without PQsetSingleRowMode, > > as follows: > > Sorry, but I don't see what is your actual ques

Re: [HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-03-31 Thread Shulgin, Oleksandr
On Apr 1, 2016 02:57, "Karl O. Pinc" wrote: > > I assume there are no questions about supporting a > similar functionality only without PQsetSingleRowMode, > as follows: Sorry, but I don't see what is your actual question here? Both code examples are going to compile and work, AFAICS. The differ

[HACKERS] PQsendQuery+PQgetResult+PQsetSingleRowMode limitations and support

2016-03-31 Thread Karl O. Pinc
Hi, Bruce Momjian suggested I write and ask about using libpq to submit multiple SQL statements to the backend, and then get results for each of the submitted statements, row-by-row without server-side caching of the results. Bruce wrote: > I think this would be good > to post to hackers to get a