Re: Getting fancy errors when accessing information_schema on 10.5

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Getting fancy errors when accessing information_schema on 10.5
Дата
Msg-id 31055688b81895792fa7d8c61e07dca7add3dbb9.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Getting fancy errors when accessing information_schema on 10.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Getting fancy errors when accessing information_schema on 10.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Subodh Kumar
Дата:
Сообщение: Re: creating table without columns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Getting fancy errors when accessing information_schema on 10.5