Mercurial > gemma
diff schema/run_tests.sh @ 4431:8fcabb6f971e
Fix operator support functions
Operators used in an operator class should not be based on SQL functions,
which might be inlined, thus preventing index usage based on the
operator.
Schema qualify functions called inside functions to make the outer
function work independendly from search_path setting. This makes
it possible to use the operators using the 'OPERATOR(<schema>.<opname>)'
syntax. Most importantly, it fixes the usage of isrs_diff() during
autovacuum.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 18 Sep 2019 17:26:28 +0200 |
parents | 5e38667f740c |
children | 0f2c3cb139cc |
line wrap: on
line diff
--- a/schema/run_tests.sh Wed Sep 18 16:36:06 2019 +0200 +++ b/schema/run_tests.sh Wed Sep 18 17:26:28 2019 +0200 @@ -80,7 +80,7 @@ -c 'SET client_min_messages TO WARNING' \ -c "DROP ROLE IF EXISTS $TEST_ROLES" \ -f "$BASEDIR"/tap_tests_data.sql \ - -c "SELECT plan(74 + ( + -c "SELECT plan(75 + ( SELECT count(*)::int FROM information_schema.tables WHERE table_schema = 'waterway'))" \