1 /* pg_hint_plan/pg_hint_plan--1.3.6.sql */
3 -- complain if script is sourced in psql, rather than via CREATE EXTENSION
4 \echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit
6 CREATE TABLE hint_plan.hints (
8 norm_query_string text NOT NULL,
9 application_name text NOT NULL,
13 CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints (
18 SELECT pg_catalog.pg_extension_config_dump('hint_plan.hints','');
19 SELECT pg_catalog.pg_extension_config_dump('hint_plan.hints_id_seq','');
21 GRANT SELECT ON hint_plan.hints TO PUBLIC;
22 GRANT USAGE ON SCHEMA hint_plan TO PUBLIC;