From: Tom Lane <tgl@sss.pgh.pa.us>
To: Axel Rau <Axel.Rau@Chaos1.DE>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Date: Tue, 30 Oct 2018 08:58:38 -0400
Message-ID: <12415.1540904318@sss.pgh.pa.us> (raw)
In-Reply-To: <97862736-B0B4-4FE6-8A6C-18CDB70C6F96@Chaos1.DE>
References: <D8BA4170-2E96-42BE-8CEC-E9FCF75B0DD4@Chaos1.DE>
<4880e067723cefc1dc2e08a117f96de26ae0f797.camel@cybertec.at>
<44D4C7B1-0DCF-4166-9DB8-B5D75EB2985E@Chaos1.DE>
<20191.1540901834@sss.pgh.pa.us>
<97862736-B0B4-4FE6-8A6C-18CDB70C6F96@Chaos1.DE>
Axel Rau <Axel.Rau@Chaos1.DE> writes:
>> Am 30.10.2018 um 13:17 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>> It doesn't happen for me either. Looking at the planner code, it seems
>> like the relkind check should happen first because it'd be cheaper than
>> the OR condition. Have you perhaps messed with the cost attributed to
>> pg_has_role(), has_sequence_privilege(), or chareq()?
> Not by intention. The instance has some history, it go back to 8.x I think.
>> You could investigate with, eg,
>>
>> select oid::regprocedure, procost from pg_proc
>> where proname = 'has_sequence_privilege';
> nextcloud=> select oid::regprocedure, procost from pg_proc
> nextcloud-> where proname = 'has_sequence_privilege';
> oid | procost
> ----------------------------------------+---------
> has_sequence_privilege(name,text,text) | 1
> has_sequence_privilege(name,oid,text) | 1
> has_sequence_privilege(oid,text,text) | 1
> has_sequence_privilege(oid,oid,text) | 1
> has_sequence_privilege(text,text) | 1
> has_sequence_privilege(oid,text) | 1
> (6 rows)
Hm, nothing surprising there, but what about the other two?
regards, tom lane
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: tgl@sss.pgh.pa.us, Axel.Rau@Chaos1.DE, laurenz.albe@cybertec.at
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
In-Reply-To: <12415.1540904318@sss.pgh.pa.us>
* 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