Обсуждение: 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..


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

=?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 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.