Thread: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
André Verwijs
Date:
psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server.. 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". -- retrieve information from tables: '>' not supported between instances of 'NoneType' and 'int' -- retrieve information from schema's has no issues. INFO PGADMIN: version 8.8 Application Mode: Desktop NW.js Version: 0.77.0 Browser: Chromium 114.0.5735.91 Operating System: Kubuntu 24.04 - Linux-6.8.0-35-generic-x86_64-with glibc2.39
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
Tom Lane
Date:
=?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
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
"David G. Johnston"
Date:
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.
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
Bruce Momjian
Date:
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.
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
Tom Lane
Date:
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
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
Bruce Momjian
Date:
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.
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..
From
Bruce Momjian
Date:
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.