Getting fancy errors when accessing information_schema on 10.5

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Getting fancy errors when accessing information_schema on 10.5
Date: 2018-10-29 22:05:11
Message-ID: D8BA4170-2E96-42BE-8CEC-E9FCF75B0DD4@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Hi all,

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?

Any help appreciated.

Axel
---
PGP-Key:29E99DD6 ☀ computing @ chaos claudius

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-10-30 07:42:41 Re: Getting fancy errors when accessing information_schema on 10.5
Previous Message Jehan-Guillaume (ioguix) de Rorthais 2018-10-29 19:58:06 Re: pgpool

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2018-10-29 22:13:07 Re: replication_slots usability issue
Previous Message Tom Lane 2018-10-29 19:48:37 Re: Should pg 11 use a lot more memory building an spgist index?