summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTom Lane2005-07-23 21:05:48 +0000
committerTom Lane2005-07-23 21:05:48 +0000
commitd007a95055b9b649b74b5d25aa4d2b46f3eca21c (patch)
treee726c049f96af578181432ae4da176cf3cbcb970 /src/test
parent9af9d674c61ca1c2e26d7a9295d5b1bcc8cabb60 (diff)
Simple constraint exclusion. For now, only child tables of inheritance
scans are candidates for exclusion; this should be fixed eventually. Simon Riggs, with some help from Tom Lane.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/rangefuncs.out25
1 files changed, 13 insertions, 12 deletions
diff --git a/src/test/regress/expected/rangefuncs.out b/src/test/regress/expected/rangefuncs.out
index 7b70766742a..3172d16b88f 100644
--- a/src/test/regress/expected/rangefuncs.out
+++ b/src/test/regress/expected/rangefuncs.out
@@ -1,16 +1,17 @@
SELECT name, setting FROM pg_settings WHERE name LIKE 'enable%';
- name | setting
--------------------+---------
- enable_bitmapscan | on
- enable_hashagg | on
- enable_hashjoin | on
- enable_indexscan | on
- enable_mergejoin | on
- enable_nestloop | on
- enable_seqscan | on
- enable_sort | on
- enable_tidscan | on
-(9 rows)
+ name | setting
+-----------------------------+---------
+ enable_bitmapscan | on
+ enable_constraint_exclusion | off
+ enable_hashagg | on
+ enable_hashjoin | on
+ enable_indexscan | on
+ enable_mergejoin | on
+ enable_nestloop | on
+ enable_seqscan | on
+ enable_sort | on
+ enable_tidscan | on
+(10 rows)
CREATE TABLE foo2(fooid int, f2 int);
INSERT INTO foo2 VALUES(1, 11);