From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Axel Rau <Axel.Rau@Chaos1.DE>
Cc: pgsql-admin@postgresql.org
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Date: Tue, 30 Oct 2018 14:18:12 +0100
Message-ID: <31055688b81895792fa7d8c61e07dca7add3dbb9.camel@cybertec.at> (raw)
In-Reply-To: <20191.1540901834@sss.pgh.pa.us>
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>
Tom Lane wrote:
> 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.
It is still unclear why the execution plan looks like that, but maybe
it would be more robust to change "has_sequence_privilege" so that it
just returns FALSE if the argument is not a sequence.
Yours,
Laurenz Albe
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, tgl@sss.pgh.pa.us, Axel.Rau@Chaos1.DE
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
In-Reply-To: <31055688b81895792fa7d8c61e07dca7add3dbb9.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