Horton

Thread

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

    André Verwijs <dutchgigalo@gmail.com> — 2024-06-26T00:35:59Z

    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

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

    Tom Lane <tgl@sss.pgh.pa.us> — 2024-06-26T00:52:23Z

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

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

    David G. Johnston <david.g.johnston@gmail.com> — 2024-06-26T00:52:47Z

    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.

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

    Bruce Momjian <bruce@momjian.us> — 2024-06-26T01:54:37Z

    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.

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

    Tom Lane <tgl@sss.pgh.pa.us> — 2024-06-26T04:06:13Z

    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

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

    Bruce Momjian <bruce@momjian.us> — 2024-06-26T13:59:35Z

    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.

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

    Bruce Momjian <bruce@momjian.us> — 2024-06-26T17:14:08Z

    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.