Horton

BUG #18998: No materialized views in INFORMATION_SCHEMA.TABLE_PRIVILEGES

PG Bug reporting form <noreply@postgresql.org>

View thread
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: lacanoid@ljudmila.org
Date: 2025-07-24T17:50:36Z
Lists: pgsql-bugs 
The following bug has been logged on the website:

Bug reference:      18998
Logged by:          Žiga Kranjec
Email address:      lacanoid@ljudmila.org
PostgreSQL version: 17.0
Operating system:   Any
Description:        

View NFORMATION_SCHEMA.TABLE_PRIVILEGES contains information for views and
tables, but not materialized views. I found this to be somewhat unexpected.

Since materialized views are conceptually somewhere between views and
tables, it would perhaps make sense to include them.

The standard of course doesn’t say anything about this because it does not
deal with materialized views at all.