On Mon, Jan 6, 2025 at 12:21 PM Stijn Sanders wrote:
> I've been using LibPQ to get data from PostgreSQL instances with great
> success.
> I'm using PQsendQuery and PQgetResult, but noticed there's also
> PQsetSingleRowMode.
> The documentation is clearly stating it only benefits a limited set o
Stijn Sanders wrote:
> From what I notice using LibPQ, it appears a query needs to complete
> before resulting data is being transferred to the client. Please
> correct me if I'm wrong.
No, the query does not need to complete. If you run something like
"select * from bigtable" in single-r
Daniel Frey wrote:
> I tried to understand 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
It's supposed to work, and there are regress
"Daniel Verite" writes:
> Stijn Sanders wrote:
>> From what I notice using LibPQ, it appears a query needs to complete
>> before resulting data is being transferred to the client. Please
>> correct me if I'm wrong.
> No, the query does not need to complete. If you run something like
> "sele
On 1/5/25 16:27, Nick wrote:
I sent this to the PgAdmin list but didn't get any replies. Not sure
how many people are on that list, but since these questions are general
enough, I figure someone on the main list will know:
I'm using the apt repository version for Debian 12 (Bookworm). I'm also
Hi,
I am currently using PostgreSQL version 16 and the test_decoding plugin to
perform logical replication (using replication slots). I have a simple
table with integer column and JSON column. When a non-JSON column is
updated, the value "unchanged-toast-datum" for the JSON column is obtained.
Thi
On Mon, Jan 6, 2025 at 7:21 AM Kiran K V wrote:
> could you please tell me whether PostgreSQL will truly log these values to
> WAL or not ? If not, what will be entered into WAL for the JSON column if
> it remains unchanged?
>
>
Not quite sure what you are looking for but:
https://www.postgresql
I've been using LibPQ to get data from PostgreSQL instances with great
success.
I'm using PQsendQuery and PQgetResult, but noticed there's
also PQsetSingleRowMode.
The documentation is clearly stating it only benefits a limited set of
scenario's, but I'm saddened that it can't help to get the first
