| Revision | 246803b901b3cd419091c14d9bb2080063841c91 (tree) |
|---|---|
| Time | 2020-07-14 15:27:39 |
| Author | egashira.yusuke <egashira.yusuke@fuji...> |
| Commiter | Kyotaro Horiguchi |
Mark hint table as a configuration table.
The table hint_plan.hints is a configuration table of
pg_hint_plan. Mark it as such, as well as its sequence table.
Back patch to pg_hint_plan96.
pg_hint_plan--1.3.5.sql (diff)| @@ -15,5 +15,8 @@ CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints ( | ||
| 15 | 15 | application_name |
| 16 | 16 | ); |
| 17 | 17 | |
| 18 | +SELECT pg_catalog.pg_extension_config_dump('hint_plan.hints',''); | |
| 19 | +SELECT pg_catalog.pg_extension_config_dump('hint_plan.hints_id_seq',''); | |
| 20 | + | |
| 18 | 21 | GRANT SELECT ON hint_plan.hints TO PUBLIC; |
| 19 | 22 | GRANT USAGE ON SCHEMA hint_plan TO PUBLIC; |
Fork