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

2017-08-16 Thread Nicolas Thauvin
On Tue, 15 Aug 2017 19:41:40 -0400 Peter Eisentraut wrote: > On 8/10/17 09:00, Nicolas Thauvin wrote: > > 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

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

2017-08-15 Thread Peter Eisentraut
On 8/10/17 09:00, Nicolas Thauvin wrote: > 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

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

2017-08-14 Thread Tom Lane
Peter Eisentraut writes: > - Materialized views not included. I think that is an intentional > omission. It's valid to reconsider, but it would be to be a separate > discussion. Yes. The problem is that matviews are not in the SQL standard, so what are you

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

2017-08-14 Thread Peter Eisentraut
On 8/11/17 04:52, Ashutosh Bapat wrote: > On Thu, Aug 10, 2017 at 6:30 PM, Nicolas Thauvin > 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

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

2017-08-11 Thread Ashutosh Bapat
On Thu, Aug 10, 2017 at 6:30 PM, Nicolas Thauvin 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

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

2017-08-10 Thread Nicolas Thauvin
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. Thanks -- Nicolas Thauvin