ヒント用テーブルの更新の制限について、文章をよりわかりやすくした。

[pghintplan/pg_hint_plan.git] / pg_hint_plan--1.0.sql

diff --git a/pg_hint_plan--1.0.sql b/pg_hint_plan--1.0.sql
index 1c5d9cb..c5deebd 100644 (file)
--- a/pg_hint_plan--1.0.sql
+++ b/pg_hint_plan--1.0.sql
@@ -4,8 +4,16 @@
 \echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit
 
 CREATE TABLE hint_plan.hints (
+       id                                      serial  NOT NULL,
        norm_query_string       text    NOT NULL,
        application_name        text    NOT NULL,
        hints                           text    NOT NULL,
-       PRIMARY KEY (norm_query_string, application_name)
+       PRIMARY KEY (id)
 );
+CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints (
+       norm_query_string,
+       application_name
+);
+
+GRANT SELECT ON hint_plan.hints TO PUBLIC;
+GRANT USAGE ON SCHEMA hint_plan TO PUBLIC;