MIME-Version: 1.0
References: <CADK3HHKe1PA1U6aB5-7tWBQ0yZGgNvY7H=ECDD9955Pas_zx_Q@mail.gmail.com>
 <CAGECzQRQ5optaG4DPbshKS+zpUtn_oceh8-qdshFbS+-FSb8Dg@mail.gmail.com>
 <CAOYmi+nVQRpSs3vd_v9L8ytO9wnL2ndnzGwU31aDGorVFxrAYA@mail.gmail.com>
 <CAGECzQSZ43JMjA8QEJoF9DCdTO0GQeR2qyhouQciSG2ik40Yhg@mail.gmail.com>
 <CAOYmi+m20jS8zZ2qFpSnvhaqGDX+vtgCsqcu9VhokyLqF8kFag@mail.gmail.com>
 <CADK3HH+DPY_x_H=e0c_AVWoUP9E+YXdyJDVvmzYEYxZXT87Agw@mail.gmail.com>
 <CAGECzQRZwbuSNp-mgPWmC97q63ODAun=pQtXa1Ru19ksz986Hg@mail.gmail.com>
 <CADK3HHKDrnRAoAcUv1ucLB0o_ZUcJRwm+jonNPNUHoDtcA9Crw@mail.gmail.com>
 <CAGECzQQriv-h_h8Ygxh_RfnLt2G4P9nWrpgMi9YL2bmcOLbUEA@mail.gmail.com>
 <CADK3HHL_cUzm-R+0nHcLvxdOZQeR0YKQMDjwLTEiGX-F9=tbeA@mail.gmail.com>
 <CADK3HH+o9dTYsXpCk7-Z0JW-QB2TV7=e97O8B-XDOGQb14AfSQ@mail.gmail.com>
 <CAOYmi+kkTbuwGa9X=XomNivAw9P4hN3M1U7QXiP7Jw+nrQXtNQ@mail.gmail.com>
 <CAGECzQSfCPXdOpUKfdkPA9iZhGyRjZAad-CXbhApZ2CnjgG2kw@mail.gmail.com>
 <CAOYmi+=qE1khrtTD7oQVPJQTHoXffQQ0DPHOx870r7801zhw9g@mail.gmail.com>
 <2155281.1767900170@sss.pgh.pa.us> <CADK3HH+6MTrMBsW+iDJ0VGzu7HQKJLLQbjnbdps3kK8Ug5prUg@mail.gmail.com>
 <CA+TgmoavFJW984Y8cUv-U9K+JqxYgqEj-i1A1dORwvyki5642A@mail.gmail.com>
 <CAGECzQSHKR2LtBSnDT_bjdpE1=cVzZLRcb2k5d_K=BMvJCFihg@mail.gmail.com> <431484.1768433414@sss.pgh.pa.us>
In-Reply-To: <431484.1768433414@sss.pgh.pa.us>
From: Dave Cramer <davecramer@gmail.com>
Date: Thu, 15 Jan 2026 05:33:11 -0500
Message-ID: <CADK3HH+TnNaW-b+d8xkUDcFZ-4oWhh5q3hCzbyuR9ShwMasHrA@mail.gmail.com>
Subject: Re: Proposal to allow setting cursor options on Portals
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jelte Fennema-Nio <postgres@jeltef.nl>, Robert Haas <robertmhaas@gmail.com>, 
	Jacob Champion <jacob.champion@enterprisedb.com>, 
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>
Content-Type: multipart/alternative; boundary="00000000000052f36b06486ac1e8"
Archived-At: <https://www.postgresql.org/message-id/CADK3HH%2BTnNaW-b%2Bd8xkUDcFZ-4oWhh5q3hCzbyuR9ShwMasHrA%40mail.gmail.com>
Precedence: bulk

--00000000000052f36b06486ac1e8
Content-Type: text/plain; charset="UTF-8"

Dave Cramer


On Wed, 14 Jan 2026 at 18:30, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Jelte Fennema-Nio <postgres@jeltef.nl> writes:
> > I feel like I've said this many times already, but I really do not
> > understand why there's such a hesitation on bumping the minor protocol
> > version. Bumping the minor protocol version has zero downsides to me.
>
> I think you have that backwards.  The right way to think about it
> is that bumping the minor version has zero upside.  What we actually
> want is for the client and server to agree on what specific optional
> features they will use, and we have a design that allows doing that
> in a fine-grained, extensible way.  We don't need to change the
> protocol version number ever again, as long as we use protocol
> options correctly.
>

I would argue in the case of "cursor with hold" this should have been in
the original protocol.
This is not an added feature this just enables an existing feature in the
server. This is not unlike widening the cancel key.
Something like encryption would be a feature that I could see using the
extension mechanism

>
> Having said that, I share Robert's distaste for "silent" protocol
> bumps that change the behavior without any negotiation.
>
My understanding reading his message he was in favour of it

As for proxies or "middleboxes" I will concede that not advertising that we
are going to change that message is a non-starter

Dave

--00000000000052f36b06486ac1e8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div><br clear=3D"all"></div><div><div di=
r=3D"ltr" class=3D"gmail_signature">Dave Cramer</div></div><br></div><br><d=
iv class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Wed, 14 Jan 2026 at 18:30, Tom Lane &lt;<a href=3D"mailto:tgl@=
sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">Jelte Fennema-Nio &lt;<a href=3D"mailto:po=
stgres@jeltef.nl" target=3D"_blank">postgres@jeltef.nl</a>&gt; writes:<br>
&gt; I feel like I&#39;ve said this many times already, but I really do not=
<br>
&gt; understand why there&#39;s such a hesitation on bumping the minor prot=
ocol<br>
&gt; version. Bumping the minor protocol version has zero downsides to me.<=
br>
<br>
I think you have that backwards.=C2=A0 The right way to think about it<br>
is that bumping the minor version has zero upside.=C2=A0 What we actually<b=
r>
want is for the client and server to agree on what specific optional<br>
features they will use, and we have a design that allows doing that<br>
in a fine-grained, extensible way.=C2=A0 We don&#39;t need to change the<br=
>
protocol version number ever again, as long as we use protocol<br>
options correctly.<br></blockquote><div><br></div><div>I would argue in the=
 case of &quot;cursor with hold&quot; this should have been in the original=
 protocol.=C2=A0</div><div>This is not an added feature this just enables a=
n existing feature in the server. This is not unlike widening the cancel ke=
y.=C2=A0</div><div>Something like encryption would be a feature that I coul=
d see using the extension mechanism</div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex">
<br>
Having said that, I share Robert&#39;s distaste for &quot;silent&quot; prot=
ocol<br>
bumps that change the behavior without any negotiation.<br></blockquote><di=
v>My understanding reading his message he was in favour of it</div><div><br=
></div><div>As for proxies or &quot;middleboxes&quot; I will concede that n=
ot advertising that we are going to change that message is a non-starter=C2=
=A0</div><div><br></div><div>Dave</div></div></div>

--00000000000052f36b06486ac1e8--