Re: [HACKERS] Foreign tables privileges not shown in information_schema.table_privileges

Поиск
Список
Период
Сортировка
От Ashutosh Bapat
Тема Re: [HACKERS] Foreign tables privileges not shown in information_schema.table_privileges
Дата
Msg-id CAFjFpRc2-FcJbw-K-x89wquZutRoA-2nrPbS0woawtyhU-f7iQ@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Foreign tables privileges not shown ininformation_schema.table_privileges  (Nicolas Thauvin <nicolas.thauvin@dalibo.com>)
Ответы Re: [HACKERS] Foreign tables privileges not shown ininformation_schema.table_privileges  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
 On Thu, Aug 10, 2017 at 6:30 PM, Nicolas Thauvin
<nicolas.thauvin@dalibo.com> wrote:
> Hello,
>
> The information_schema.table_privileges view filters on regular tables
> and views. Foreign tables are not shown in this view but they are in
> other views of the information_schema like tables or column_privileges.
>
> Is it intentional? A patch is attached if not.

The line was first added by 596652d6 and updated by 262e821d to
include partitioned tables. Looks like we have forgot to add tables
added in between i.e. foreign tables and materialized views.
column_privileges doesn't have materialized views. Attached patch adds
materialized views to column_privileges view along with your changes.

Please add this to the next commitfest so that it doesn't get forgotten.

-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] POC: Sharing record typmods between backends
Следующее
От: Rushabh Lathia
Дата:
Сообщение: Re: [HACKERS] reload-through-the-top-parent switch the partition table