File: hint_table.sql

package info (click to toggle)
pg-hint-plan-17 1.7.0-1
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 2,768 kB
  • sloc: sql: 4,516; ansic: 4,436; lex: 1,155; perl: 288; makefile: 78; python: 10; sh: 2
file content (14 lines) | stat: -rw-r--r-- 387 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
-- 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;
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;
SET pg_hint_plan.enable_hint_table TO off;
DROP EXTENSION pg_hint_plan;