Re: protocol-level wait-for-LSN - Mailing list pgsql-hackers

From Jesper Pedersen
Subject Re: protocol-level wait-for-LSN
Date
Msg-id 71d5bd2f-504f-4bad-9594-e07439cd4330@comcast.net
Whole thread Raw
In response to Re: protocol-level wait-for-LSN  (Jesper Pedersen <jesper.pedersen@comcast.net>)
List pgsql-hackers
Hi,

On 10/29/24 12:03 PM, Jesper Pedersen wrote:
> On 10/28/24 12:58 PM, Heikki Linnakangas wrote:
>> I'd suggest adding a new message type for this, so that it works the 
>> same with simple and extended query. Or if you just want to wait 
>> without issuing any query.
> 
> I agree it is a good idea to have a feature like this.
> 
> However, I agree with Heikki that we should have a separate message type 
> for this. There are a lot of protocol implementations outside of 
> PostgreSQL/Core, and they would have to adjust based on the version 
> number of Core itself if we add fields to existing message types.
> 
> Maybe there should be an "Extension ('x') (F)" message that only has a 
> fixed "header", and the rest of the fields are based on the "header" 
> limited by the message length field - sort of free-form. The result is 
> returned as a "DataRow ('D') (B)" list.
>

I understand that we need this to be "atomic" which is difficult with 
the above since we can already use "Query 'Q' (F)", but we need it at 
"ReadyForQuery 'Z' (B)" level.

Having a new "ReadyForQuery v2 ('z') (B)" would require changes to all 
non-Core implementations as well...

Likely a protocol v4 thing.

Best regards,
  Jesper





pgsql-hackers by date:

Previous
From: Jesper Pedersen
Date:
Subject: Re: protocol-level wait-for-LSN
Next
From: Paul Ramsey
Date:
Subject: Re: RFC: Extension Packaging & Lookup