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 views of the information_schema like
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 attac
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 going to show in tables.table_type?
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 views of the information_sche
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 column_privileges.
>
> Is it in
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
htt