OSDN Git Service

Mark hint table as a configuration table.
authoregashira.yusuke <egashira.yusuke@fujitsu.com>
Fri, 26 Jun 2020 11:09:51 +0000 (20:09 +0900)
committerKyotaro Horiguchi <horikyota.ntt@gmail.com>
Tue, 14 Jul 2020 06:27:15 +0000 (15:27 +0900)
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

index 6e7ea47..dd32dfc 100644 (file)
@@ -15,5 +15,8 @@ CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints (
        application_name
 );
 
+SELECT pg_catalog.pg_extension_config_dump('hint_plan.hints','');
+SELECT pg_catalog.pg_extension_config_dump('hint_plan.hints_id_seq','');
+
 GRANT SELECT ON hint_plan.hints TO PUBLIC;
 GRANT USAGE ON SCHEMA hint_plan TO PUBLIC;