BUG #18998: No materialized views in INFORMATION_SCHEMA.TABLE_PRIVILEGES - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18998: No materialized views in INFORMATION_SCHEMA.TABLE_PRIVILEGES
Date
Msg-id 18998-d0b1ca418d70eed4@postgresql.org
Whole thread Raw
Responses Re: BUG #18998: No materialized views in INFORMATION_SCHEMA.TABLE_PRIVILEGES
List 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.


pgsql-bugs by date:

Previous
From: "Jinhui Lai"
Date:
Subject: Re: BUG #18997: Two equivalent queries return different results
Next
From: Fujii Masao
Date:
Subject: Re: Unexpected Standby Shutdown on sync_replication_slots change