Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Foreign tables privileges not shown in information_schema.table_privileges - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: [HACKERS] Foreign tables privileges not shown in information_schema.table_privileges
Date
Msg-id CAFjFpRc2-FcJbw-K-x89wquZutRoA-2nrPbS0woawtyhU-f7iQ@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Foreign tables privileges not shown ininformation_schema.table_privileges  (Nicolas Thauvin <nicolas.thauvin@dalibo.com>)
Responses Re: [HACKERS] Foreign tables privileges not shown ininformation_schema.table_privileges  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view 
 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
Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [HACKERS] POC: Sharing record typmods between backends
Next
From: Rushabh Lathia
Date:
Subject: Re: [HACKERS] reload-through-the-top-parent switch the partition table