Pipeline Mode vs Single Row Mode / Chunked Rows Mode - Mailing list pgsql-general

From Daniel Frey
Subject Pipeline Mode vs Single Row Mode / Chunked Rows Mode
Date
Msg-id A86C45C5-4E99-49B8-93E0-EEDC3DA4235B@gmx.de
Whole thread Raw
List pgsql-general
Hi,

I'm adding support for Pipeline Mode to my C++ PostgreSQL client library (https://github.com/taocpp/taopq) and I tried
tounderstand the interaction between Pipeline Mode and Single Row Mode / Chunked Rows Mode. It seems that it works
sometimes,but I don't get the feeling that it was deliberately designed to work consistently. Example: 

* Consider a table with three rows of data
* I send two (identical) SELECT commands, e.g. "SELECT * FROM test_table"
* I call PQpipelineSync()
* I call PQsetSingleRowMode()
* I read the results, I get
  * One result with size 1
  * Another one with size 1
  * Another one with size 1
  * A final one with size 0 for the first select
  * A result with size 3 for the second select
  * A result with PGRES_PIPELINE_SYNC

When I try to call PQsetSingleRowMode() for the second SELECT, it fails.
It also seems weird that I can call it for the first result after the sync call, but maybe that's OK?

Anyway, is there some documentation about how these modes interact and how they can be combined? Or should they never
becombined? 

-Daniel




pgsql-general by date:

Previous
From: Adrian Garcia Badaracco
Date:
Subject: Re: Wrapping a where clause to preserve rows with nulls
Next
From: Adrian Klaver
Date:
Subject: Re: Issue with pg_dump due to Schema OID Error