From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?Q?Mike_Fr=C3=B6hner?= <mikefroehner@gmx.de>
cc: Julien Rouhaud <rjuju123@gmail.com>, pgsql-bugs@lists.postgresql.org
Subject: Re: =?UTF-8?Q?Aw=3A_Re=3A_=C2=A0BUG_=2317647=3A_12=2E12_packa?=
 =?UTF-8?Q?ge_has_difference_on_ubuntu_18=2E04?=
In-reply-to: 
 <trinity-442a796d-9e1a-4845-b6b5-197fad011c08-1666116814878@3c-app-gmx-bap13>
References: <17647-355ab16b3ab3c775@postgresql.org>
 <trinity-aee76dd0-5787-4adc-8c24-ce1a081277fa-1666081158225@msvc-mesg-gmx003>
 <Y06fn/2t3y6cp5VQ@jrouhaud> <20221018132519.tt3feryowdyhdvbn@jrouhaud>
 <trinity-442a796d-9e1a-4845-b6b5-197fad011c08-1666116814878@3c-app-gmx-bap13>
Comments: In-reply-to =?UTF-8?Q?Mike_Fr=C3=B6hner?= <mikefroehner@gmx.de>
	message dated "Tue, 18 Oct 2022 20:13:34 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2733625.1666127261.1@sss.pgh.pa.us>
Date: Tue, 18 Oct 2022 17:07:41 -0400
Message-ID: <2733626.1666127261@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2733626.1666127261%40sss.pgh.pa.us>
Precedence: bulk

=?UTF-8?Q?Mike_Fr=C3=B6hner?= <mikefroehner@gmx.de> writes:
> But to ensure we understand correctly - I am not talking about pg14 or
> pg15. We have noticed the changed behavior ONLY while using
> postgresql-12 package on Ubuntu 18.04 with libpq5 upgraded from
> 14.5-1.pgdg18.04+1 to 15.0-1.pgdg18.04+1 and postgresql-client-common +
> postgresql-common upgraded from 243.pgdg18.04+1 to 244.pgdg18.04+1.

It's libpq that determines this behavior, not the server, so I find
nothing whatever surprising in your statement.

> For now I am fine with adjusted command in our testing suite. But it is
> still strange the same command works on all versions of Ubuntu LTS but
> not on Ubuntu 18.04.

Probably they've not updated libpq so quickly in the LTS distros.

			regards, tom lane