psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..

=?UTF-8?Q?Andr=C3=A9_Verwijs?= <dutchgigalo@gmail.com> writes:

retrieve information from database:
column "daticulocale" does not exist
LINE 5: datconnlimit, daticulocale, daticurules, datcollversion,
^
HINT: Perhaps you meant to reference the column "db.datlocale".

I'm guessing you need to complain to the pgadmin folks about this?
AFAICS there is no client included in core postgres that would
generate a query spelled exactly like this, and certainly none
that would try to do so against a v17 server.

regards, tom lane

On Tue, Jun 25, 2024 at 5:36 PM André Verwijs <dutchgigalo@gmail.com> wrote:

psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e)

column "daticulocale" does not exist
LINE 5: datconnlimit, daticulocale, daticurules, datcollversion,
^
HINT: Perhaps you meant to reference the column "db.datlocale".
--

INFO PGADMIN:

We seem to be missing a release note item for the catalog breakage done in
f696c0c

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f696c0cd5f

David J.

On Tue, Jun 25, 2024 at 05:52:47PM -0700, David G. Johnston wrote:

On Tue, Jun 25, 2024 at 5:36 PM André Verwijs <dutchgigalo@gmail.com> wrote:

psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e)

column "daticulocale" does not exist
LINE 5: datconnlimit, daticulocale, daticurules, datcollversion,
^
HINT: Perhaps you meant to reference the column "db.datlocale".
--

INFO PGADMIN:

 We seem to be missing a release note item for the catalog breakage done in
 f696c0c

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f696c0cd5f

It seemed too internal to mention in the release notes --- more of an
infrastructure change, but I can add it if I was wrong about this.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

Bruce Momjian <bruce@momjian.us> writes:

On Tue, Jun 25, 2024 at 05:52:47PM -0700, David G. Johnston wrote:

We seem to be missing a release note item for the catalog breakage done in
f696c0c
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f696c0cd5f

It seemed too internal to mention in the release notes --- more of an
infrastructure change, but I can add it if I was wrong about this.

As this breakage demonstrates, that change is quite
application-visible. It needs an entry under incompatibilities.

regards, tom lane

On Wed, Jun 26, 2024 at 12:06:13AM -0400, Tom Lane wrote:

Bruce Momjian <bruce@momjian.us> writes:

On Tue, Jun 25, 2024 at 05:52:47PM -0700, David G. Johnston wrote:

We seem to be missing a release note item for the catalog breakage done in
f696c0c
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f696c0cd5f

It seemed too internal to mention in the release notes --- more of an
infrastructure change, but I can add it if I was wrong about this.

As this breakage demonstrates, that change is quite
application-visible. It needs an entry under incompatibilities.

Okay, will do today.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

On Wed, Jun 26, 2024 at 09:59:35AM -0400, Bruce Momjian wrote:

On Wed, Jun 26, 2024 at 12:06:13AM -0400, Tom Lane wrote:

Bruce Momjian <bruce@momjian.us> writes:

On Tue, Jun 25, 2024 at 05:52:47PM -0700, David G. Johnston wrote:

We seem to be missing a release note item for the catalog breakage done in
f696c0c
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f696c0cd5f

It seemed too internal to mention in the release notes --- more of an
infrastructure change, but I can add it if I was wrong about this.

As this breakage demonstrates, that change is quite
application-visible. It needs an entry under incompatibilities.

Okay, will do today.

Done.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.