pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feederror message
6+ messages / 5 participants
[nested] [flat]
* error message
@ 2000-08-16 05:50 root <faisal@ssmat.com>
0 siblings, 0 replies; 6+ messages in thread
From: root @ 2000-08-16 05:50 UTC (permalink / raw)
To: pgsql-admin
Hello there...
I've compile postgreSQL 7.0.2 but I got an error message...Below is the
error...
gcc: Internal compiler error: program cc1 got fatal signal 11
gmake[3]: *** [hio.o] Error 1
gmake[3]: Leaving directory
`/tmp/postgresql-7.0.2/src/backend/access/heap'
gmake[2]: *** [submake] Error 2
gmake[2]: Leaving directory `/tmp/postgresql-7.0.2/src/backend/access'
gmake[1]: *** [access.dir] Error 2
gmake[1]: Leaving directory `/tmp/postgresql-7.0.2/src/backend'
gmake: *** [all] Error 2
Is it my compiler have problem..For your information I am using
- RedHat 6.1
- gcc (egcs-2.91.66)
- kernel (2.2.12-20)
If I need to update to the new version please inform me...
Thanks in advanced
Regards
Faisal
SE
^ permalink raw reply [nested|flat] 6+ messages in thread
* Error Message
@ 2020-05-04 15:28 Brian Hansen <dulanic@gmail.com>
2020-05-04 15:34 ` Re: Error Message David G. Johnston <david.g.johnston@gmail.com>
2020-05-04 15:51 ` Fwd: Error Message Brian Hansen <dulanic@gmail.com>
2020-05-04 16:43 ` Re: Error Message Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 3 replies; 6+ messages in thread
From: Brian Hansen @ 2020-05-04 15:28 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error Message
2020-05-04 15:28 Error Message Brian Hansen <dulanic@gmail.com>
@ 2020-05-04 15:34 ` David G. Johnston <david.g.johnston@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2020-05-04 15:34 UTC (permalink / raw)
To: Brian Hansen <dulanic@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, May 4, 2020 at 8:29 AM Brian Hansen <dulanic@gmail.com> 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 is a list for general administration questions pertain to the
PostgreSQL server.
The list for the independent pgAdmin4 product is:
pgadmin-support
As noted on their website:
https://www.pgadmin.org/support/list/
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Fwd: Error Message
2020-05-04 15:28 Error Message Brian Hansen <dulanic@gmail.com>
@ 2020-05-04 15:51 ` Brian Hansen <dulanic@gmail.com>
2020-05-05 05:51 ` Re: Error Message Akshay Joshi <akshay.joshi@enterprisedb.com>
2 siblings, 1 reply; 6+ messages in thread
From: Brian Hansen @ 2020-05-04 15:51 UTC (permalink / raw)
To: pgadmin-support@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error Message
2020-05-04 15:28 Error Message Brian Hansen <dulanic@gmail.com>
2020-05-04 15:51 ` Fwd: Error Message Brian Hansen <dulanic@gmail.com>
@ 2020-05-05 05:51 ` Akshay Joshi <akshay.joshi@enterprisedb.com>
0 siblings, 0 replies; 6+ messages in thread
From: Akshay Joshi @ 2020-05-05 05:51 UTC (permalink / raw)
To: Brian Hansen <dulanic@gmail.com>; +Cc: pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Hi Brian
Can you please provide the exact steps to reproduce? It seems that you are
using PostgreSQL/EDB Postgres Advanced Server 12.
I have tried to reproduce the issue based on the query you have specified,
but unable to find any issue.
On Mon, May 4, 2020 at 9:22 PM Brian Hansen <dulanic@gmail.com> 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
>
>
>
--
*Thanks & Regards*
*Akshay Joshi*
*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error Message
2020-05-04 15:28 Error Message Brian Hansen <dulanic@gmail.com>
@ 2020-05-04 16:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2 siblings, 0 replies; 6+ messages in thread
From: Laurenz Albe @ 2020-05-04 16:43 UTC (permalink / raw)
To: Brian Hansen <dulanic@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2020-05-05 05:51 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-16 05:50 error message root <faisal@ssmat.com>
2020-05-04 15:28 Error Message Brian Hansen <dulanic@gmail.com>
2020-05-04 15:34 ` Re: Error Message David G. Johnston <david.g.johnston@gmail.com>
2020-05-04 15:51 ` Fwd: Error Message Brian Hansen <dulanic@gmail.com>
2020-05-05 05:51 ` Re: Error Message Akshay Joshi <akshay.joshi@enterprisedb.com>
2020-05-04 16:43 ` Re: Error Message Laurenz Albe <laurenz.albe@cybertec.at>
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