projects
/
plantuner.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
forbid_index => disable_index. Introduce enable_index overloads disable_index
[plantuner.git]
/
expected
/
plantuner.out
diff --git
a/expected/plantuner.out
b/expected/plantuner.out
index
e279d83
..
0d372ca
100644
(file)
--- a/
expected/plantuner.out
+++ b/
expected/plantuner.out
@@
-1,7
+1,7
@@
LOAD 'plantuner';
LOAD 'plantuner';
-SHOW plantuner.
forbid
_index;
- plantuner.
forbid
_index
-------------------------
+SHOW plantuner.
disable
_index;
+ plantuner.
disable
_index
+------------------------
-
(1 row)
(1 row)
@@
-14,24
+14,36
@@
SELECT * FROM wow;
---+---
(0 rows)
---+---
(0 rows)
-SET plantuner.
forbid
_index="i_idx, j_idx";
+SET plantuner.
disable
_index="i_idx, j_idx";
SELECT * FROM wow;
i | j
---+---
(0 rows)
SELECT * FROM wow;
i | j
---+---
(0 rows)
-SHOW plantuner.
forbid
_index;
-
plantuner.forbid
_index
+SHOW plantuner.
disable
_index;
+
plantuner.disable
_index
----------------------------
public.i_idx, public.j_idx
(1 row)
----------------------------
public.i_idx, public.j_idx
(1 row)
-SET plantuner.
forbid
_index="i_idx, nonexistent, public.j_idx, wow";
+SET plantuner.
disable
_index="i_idx, nonexistent, public.j_idx, wow";
WARNING: 'nonexistent' does not exist
WARNING: 'wow' is not an index
WARNING: 'nonexistent' does not exist
WARNING: 'wow' is not an index
-SHOW plantuner.
forbid
_index;
-
plantuner.forbid
_index
+SHOW plantuner.
disable
_index;
+
plantuner.disable
_index
----------------------------
public.i_idx, public.j_idx
(1 row)
----------------------------
public.i_idx, public.j_idx
(1 row)
+SET plantuner.enable_index="i_idx";
+SHOW plantuner.enable_index;
+ plantuner.enable_index
+------------------------
+ public.i_idx
+(1 row)
+
+SELECT * FROM wow;
+ i | j
+---+---
+(0 rows)
+