-- Tests for the hint table
LOAD 'pg_hint_plan';
-- Attempting to use the hint table without the extension created
-- emits a WARNING.
SET pg_hint_plan.enable_hint_table TO on;
SELECT 1;
WARNING:  cannot use the hint table
HINT:  Run "CREATE EXTENSION pg_hint_plan" to create the hint table.
 ?column? 
----------
        1
(1 row)

SET pg_hint_plan.enable_hint_table TO off;
CREATE EXTENSION pg_hint_plan;
SET pg_hint_plan.enable_hint_table TO on;
SELECT 1;
 ?column? 
----------
        1
(1 row)

SET pg_hint_plan.enable_hint_table TO off;
DROP EXTENSION pg_hint_plan;