From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Axel Rau <Axel.Rau@chaos1.de>
To: pgsql-admin@postgresql.org
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Date: Tue, 30 Oct 2018 08:42:41 +0100
Message-ID: <4880e067723cefc1dc2e08a117f96de26ae0f797.camel@cybertec.at> (raw)
In-Reply-To: <D8BA4170-2E96-42BE-8CEC-E9FCF75B0DD4@Chaos1.DE>
References: <D8BA4170-2E96-42BE-8CEC-E9FCF75B0DD4@Chaos1.DE>
Axel Rau wrote:
> here is an example:
>
> SELECT sequence_name AS relname, sequence_schema AS schemaname
> FROM information_schema.sequences
> WHERE sequence_schema NOT LIKE 'pg\_%' AND sequence_schema != ‚information_schema'': SQLSTATE[42809]: Wrong object type: 7 ERROR: "pg_statistic" is not a sequence
>
> This does not happen as SUPERUSER.
> Is this a known bug?
The statement as you wrote it is syntactically incorrect.
Did some program mutilate your quotes in transfer?
Anyway, the error message does not make much sense.
Could you run EXPLAIN on the query and tell us the execution plan?
Perhaps this is some fancy kind of catalog corruption...
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, Axel.Rau@chaos1.de
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
In-Reply-To: <4880e067723cefc1dc2e08a117f96de26ae0f797.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