How to perform update on pg_index

0

We are using a RDS Postgres 15 and have a use case that requires disabling specific indexes using pg_index table but all attempts result in ERROR: permission denied for table pg_index . We've tried granting permissions and altering schema but still receive the same error.

Thanks for any assistance

Steve
已提問 4 個月前檢視次數 427 次
1 個回答
0

Hi,

Regrettably disabling indexes using pg_index will not be possible as pg_index is owned by rdsadmin:

postgres=> \dt+ pg_index
                              List of relations
   Schema   |   Name   | Type  |  Owner   | Persistence | Size  | Description
------------+----------+-------+----------+-------------+-------+-------------
 pg_catalog | pg_index | table | rdsadmin | permanent   | 56 kB |
(1 row)

Users within RDS are not allowed to modify system catalogs in RDS/Aurora PostgreSQL.

AWS
支援工程師
Kyle_B
已回答 2 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南