2 SET pg_hint_plan.enable TO on;
3 SET pg_hint_plan.debug_print TO on;
4 SET search_path TO public;
6 ---- No. G-2-2 category of GUC parameter and role
10 /*+Set(block_size 16384)*/
11 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
12 INFO: parameter "block_size" cannot be changed
19 /*+Set(archive_mode off)*/
20 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
21 INFO: parameter "archive_mode" cannot be changed without restarting the server
28 /*+Set(archive_timeout 0)*/
29 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
30 INFO: parameter "archive_timeout" cannot be changed now
37 /*+Set(log_connections off)*/
38 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
39 INFO: parameter "log_connections" cannot be set after connection start
46 /*+Set(log_min_messages WARNING)*/
47 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
55 GRANT ALL ON SCHEMA s1 TO PUBLIC;
56 GRANT SELECT ON ALL TABLES IN SCHEMA s1 TO normal_user;
58 /*+Set(log_min_messages WARNING)*/
59 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
60 INFO: permission denied to set parameter "log_min_messages"
67 /*+Set(enable_seqscan on)*/
68 SELECT * FROM s1.t1 WHERE t1.c1 = 1;
75 REVOKE SELECT ON ALL TABLES IN SCHEMA s1 FROM normal_user;
76 REVOKE ALL ON SCHEMA s1 FROM PUBLIC;
78 ---- No. G-2-3 conflict set hint
80 SET client_min_messages TO LOG;
82 /*+Set(enable_indexscan on)Set(enable_indexscan off)*/
83 SELECT * FROM s1.t1 WHERE false;
84 INFO: hint syntax error at or near "Set(enable_indexscan on)Set(enable_indexscan off)"
85 DETAIL: Conflict set hint.
88 Set(enable_indexscan off)
91 Set(enable_indexscan on)
99 /*+Set(client_min_messages DEBUG5)Set(client_min_messages WARNING)Set(client_min_messages DEBUG2)*/
100 SELECT * FROM s1.t1 WHERE false;
101 INFO: hint syntax error at or near "Set(client_min_messages DEBUG5)Set(client_min_messages WARNING)Set(client_min_messages DEBUG2)"
102 DETAIL: Conflict set hint.
103 INFO: hint syntax error at or near "Set(client_min_messages WARNING)Set(client_min_messages DEBUG2)"
104 DETAIL: Conflict set hint.
107 Set(client_min_messages DEBUG2)
110 Set(client_min_messages DEBUG5)
111 Set(client_min_messages WARNING)
119 /*+Set(enable_indexscan on)Set(enable_indexscan o)*/
120 SELECT * FROM s1.t1 WHERE false;
121 INFO: hint syntax error at or near "Set(enable_indexscan on)Set(enable_indexscan o)"
122 DETAIL: Conflict set hint.
123 INFO: parameter "enable_indexscan" requires a Boolean value
128 Set(enable_indexscan on)
130 Set(enable_indexscan o)
137 /*+Set(client_min_messages DEBUG5)Set(client_min_messages WARNING)Set(client_min_messages DEBU)*/
138 SELECT * FROM s1.t1 WHERE false;
139 INFO: hint syntax error at or near "Set(client_min_messages DEBUG5)Set(client_min_messages WARNING)Set(client_min_messages DEBU)"
140 DETAIL: Conflict set hint.
141 INFO: hint syntax error at or near "Set(client_min_messages WARNING)Set(client_min_messages DEBU)"
142 DETAIL: Conflict set hint.
143 INFO: invalid value for parameter "client_min_messages": "DEBU"
144 HINT: Available values: debug5, debug4, debug3, debug2, debug1, log, notice, warning, error.
149 Set(client_min_messages DEBUG5)
150 Set(client_min_messages WARNING)
152 Set(client_min_messages DEBU)