Re: Getting fancy errors when accessing information_schema on 10.5

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Date: 2018-10-30 13:18:12
Message-ID: 31055688b81895792fa7d8c61e07dca7add3dbb9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2018-10-30 13:45:34 Re: Getting fancy errors when accessing information_schema on 10.5
Previous Message Subodh Kumar 2018-10-30 13:15:49 Re: creating table without columns

Browse pgsql-hackers by date

  From Date Subject
Next Message Uday Bhaskar V 2018-10-30 13:22:15 Re: Sequential UUID Generation
Previous Message Tomas Vondra 2018-10-30 13:13:33 Re: Sequential UUID Generation