Getting fancy errors when accessing information_schema on 10.5 - Mailing list pgsql-admin

From Axel Rau
Subject Getting fancy errors when accessing information_schema on 10.5
Date
Msg-id D8BA4170-2E96-42BE-8CEC-E9FCF75B0DD4@Chaos1.DE
Whole thread Raw
Responses Re: Getting fancy errors when accessing information_schema on 10.5  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: "Jehan-Guillaume (ioguix) de Rorthais"
Date:
Subject: Re: pgpool
Next
From: Laurenz Albe
Date:
Subject: Re: Getting fancy errors when accessing information_schema on 10.5