"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
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
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
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
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
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 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
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
