Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs
Date
Msg-id CADK3HHL1aZXoKKfr07wW80QAwLPLKC3WjBTAhSDH4fh=Wz8ivw@mail.gmail.com
Whole thread Raw
In response to Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs
List pgsql-hackers


On Fri, 16 Aug 2024 at 15:54, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
On 16/08/2024 22:45, Dave Cramer wrote:
> On Fri, 16 Aug 2024 at 15:26, Heikki Linnakangas <hlinnaka@iki.fi
> <mailto:hlinnaka@iki.fi>> wrote:
>
>     On 16/08/2024 21:01, Robert Haas wrote:
>      > On Fri, Aug 16, 2024 at 1:44 PM Jacob Champion
>      > <jacob.champion@enterprisedb.com
>     <mailto:jacob.champion@enterprisedb.com>> wrote:
>      >>
>     https://github.com/psycopg/psycopg2/blob/658afe4cd90d3e167d7c98d22824a8d6ec895b1c/tests/test_async.py#L89 <https://github.com/psycopg/psycopg2/blob/658afe4cd90d3e167d7c98d22824a8d6ec895b1c/tests/test_async.py#L89>
>      >>
>     https://github.com/infusion/PHP/blob/7ebefb6426bb4b4820a30cca5c3a10bfd757b6ea/ext/pgsql/pgsql.c#L864 <https://github.com/infusion/PHP/blob/7ebefb6426bb4b4820a30cca5c3a10bfd757b6ea/ext/pgsql/pgsql.c#L864>
>      >
>      > IMHO these examples establish beyond doubt that the existing function
>      > really is being used in ways that would break if we committed the
>      > proposed patch. To be honest, I'm slightly surprised, because
>     protocol
>      > version 2 has been so dead for so long that I would not have
>      > anticipated people would even bother checking for it. But these
>      > examples show that some people do. If Jacob found these examples this
>      > easily, there are probably a bunch of others.
>      >
>      > It's not worth breaking existing code to avoid adding one new libpq
>      > entrypoint. Let's just add the new function and move on.
>
>     +1. Jacob is right.
>
>
> For those of us who don't use a function. How will this work ?

Sorry, I don't understand the question. This sub-thread is all about the
libpq PQprotocolVersion() function.

Admittedly I'm a bit late into this discussion so I may be off base. 
Ultimately we need to negotiate the protocol. From what I can tell for libpq we are providing a function that returns a number, currently 3. 

The proposal is to change it to something like 30000. 

Ultimately this has to go over the wire so that clients that are implementing the protocol themselves can respond to the new behaviour.

Wouldn't we have to send this number in the protocol negotiation ? 

Dave

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs
Next
From: Robert Haas
Date:
Subject: Re: pg_verifybackup: TAR format backup verification