Lack of information on materialized views ininformation_schema.table_privileges.

Hi,
after:create schema test_schema;create materialized view test_schema.test_mat_view as select 1;grant select on
test_schema.test_mat_viewto public; 

information_schema.table_privileges does not show privileges on the view:select grantee, string_agg(privilege_type, ',
')as privilegesfrom information_schema.table_privilegeswhere table_schema = 'test_schema' and table_name =
'test_mat_view'groupby grantee; 
 grantee | privileges ---------+------------(0 rows)

Should be:
 grantee  |                          privileges
----------+---------------------------------------------------------------postgres | INSERT, SELECT, UPDATE, DELETE,
TRUNCATE,REFERENCES, TRIGGER PUBLIC   | SELECT(2 rows) 
Of course, privileges are properly defined in pg_class:    select relname, relnamespace::regnamespace, relaclfrom
pg_classwhererelnamespace = 'test_schema'::regnamespace and relname = 
'test_mat_view';
    relname    | relnamespace |                 relacl
---------------+--------------+-----------------------------------------test_mat_view | test_schema  |
{postgres=arwdDxt/postgres,=r/postgres}(1rows) 

Related post on stackoverflow.com:
https://stackoverflow.com/questions/38728548/list-grants-and-privileges-for-a-materialized-view-in-postgresql

------
Jan Przemysław Wójcik



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html