From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Brian Hansen <dulanic@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Error Message
Date: Mon, 04 May 2020 18:43:35 +0200
Message-ID: <a6fea837d96f2ae9a685503fe951512befc650cb.camel@cybertec.at> (raw)
In-Reply-To: <CAMiuOHUKZsorxboCXObDiOiAVRT4Ub-2+GD2eFTiEoUF6qnQdg@mail.gmail.com>
References: <CAMiuOHUKZsorxboCXObDiOiAVRT4Ub-2+GD2eFTiEoUF6qnQdg@mail.gmail.com>
On Mon, 2020-05-04 at 10:28 -0500, Brian Hansen wrote:
> So I installed pgAdmin 4 and many times when I am going to certain
> sections, it errors out showing this error.
> https://snipboard.io/TyU8b3.jpg
>
> This error is always caused by the LENGTH(spc.spcname) portion of the
> query.....and it can be corrected by updating to
> LENGTH(spc.spcname::text), but I can't find that this can be
> customized on my side and it's built into pgadmin? Unless I am
> wrong...
>
> The full query that pgadmin is running that errors is here:
> https://pastebin.com/SrTWp8bm
>
> Version: 4.21
> OS: Windows 10
> Desktop mode
> Postgresql version: Docker postgres:12.2
If I look at the error message and have to guess, I'd say that you have
created a type or domain "length", which leads to confusion with the
"length(text)" function:
CREATE DOMAIN length AS text;
SELECT length('something') < 42;
ERROR: operator does not exist: length < integer
LINE 1: SELECT length('something') < 42;
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
Workaround: don't use "length" as the name of a custom object.
But a query run by pgAdmin should still not fail.
You should write to the pgadmin mailing list and tell them what object
"length" you created and how to reproduce the error.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, dulanic@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Error Message
In-Reply-To: <a6fea837d96f2ae9a685503fe951512befc650cb.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox