Getting fancy errors when accessing information_schema on 10.5
Axel Rau <axel.rau@chaos1.de>
From: Axel Rau <Axel.Rau@chaos1.de>
To: pgsql-admin@postgresql.org
Date: 2018-10-29T22:05:11Z
Lists: 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