データの更新を容易にするために、ヒント用テーブルにid列を追加した。

diff --git a/pg_hint_plan--1.0.sql b/pg_hint_plan--1.0.sql
index 1c5d9cb..d07351a 100644 (file)
--- a/pg_hint_plan--1.0.sql
+++ b/pg_hint_plan--1.0.sql
@@ -4,8 +4,9 @@
 \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)
 );