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

From Laurenz Albe
Subject Re: Getting fancy errors when accessing information_schema on 10.5
Date
Msg-id 31055688b81895792fa7d8c61e07dca7add3dbb9.camel@cybertec.at
Whole thread Raw
In response to Re: Getting fancy errors when accessing information_schema on 10.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Getting fancy errors when accessing information_schema on 10.5
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Subodh Kumar
Date:
Subject: Re: creating table without columns
Next
From: Tom Lane
Date:
Subject: Re: Getting fancy errors when accessing information_schema on 10.5