EXTENSION機構の試験のSQLを追加した

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

diff --git a/sql/pg_hint_plan.sql b/sql/pg_hint_plan.sql
index 474d6b2..1034fc9 100644 (file)
--- a/sql/pg_hint_plan.sql
+++ b/sql/pg_hint_plan.sql
@@ -824,9 +824,9 @@ EXPLAIN (COSTS false) SELECT val FROM p1 WHERE val = 1;
 
 -- search from hint table
 INSERT INTO hint_plan.hints VALUES ('EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = ?;', '', 'SeqScan(t1)');
-SET pg_hint_plan.lookup_hint_in_table = on;
+SET pg_hint_plan.enable_hint_table = on;
 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = 1;
-SET pg_hint_plan.lookup_hint_in_table = off;
+SET pg_hint_plan.enable_hint_table = off;
 EXPLAIN (COSTS false) SELECT * FROM t1 WHERE t1.id = 1;
 TRUNCATE hint_plan.hints;
 VACUUM ANALYZE hint_plan.hints;
@@ -841,3 +841,4 @@ BEGIN
        RETURN;
 END;
 $$;
+DROP EXTENSION pg_hint_plan;