summaryrefslogtreecommitdiff
path: root/contrib/pg_trgm/sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2007-11-13 06:29:04 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2007-11-13 06:29:04 +0000
commit30e2c42e00a501278ffe80223bada52e2ba269f3 (patch)
treef568c076a58ce277ed2e1f58fc0b767bda19d607 /contrib/pg_trgm/sql
parent0614c5e5fd93bd71a293d7c4e694b06a20c9a70c (diff)
downloadpostgresql-30e2c42e00a501278ffe80223bada52e2ba269f3.tar.gz
Fix a few contrib regression test scripts that hadn't gotten the word
about best practice for including the module creation scripts: to wit that you should suppress NOTICE messages. This avoids creating regression failures by adding or removing comment lines in the module scripts.
Diffstat (limited to 'contrib/pg_trgm/sql')
-rw-r--r--contrib/pg_trgm/sql/pg_trgm.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/contrib/pg_trgm/sql/pg_trgm.sql b/contrib/pg_trgm/sql/pg_trgm.sql
index 018ad85872..13045827ac 100644
--- a/contrib/pg_trgm/sql/pg_trgm.sql
+++ b/contrib/pg_trgm/sql/pg_trgm.sql
@@ -1,6 +1,12 @@
+--
+-- first, define the datatype. Turn off echoing so that expected file
+-- does not depend on contents of pg_tgrm.sql.
+--
+SET client_min_messages = warning;
\set ECHO none
\i pg_trgm.sql
\set ECHO all
+RESET client_min_messages;
select show_trgm('');
select show_trgm('(*&^$@%@');