summaryrefslogtreecommitdiff
path: root/contrib/pgcrypto
diff options
context:
space:
mode:
authorTom Lane2007-11-13 06:29:04 +0000
committerTom Lane2007-11-13 06:29:04 +0000
commit30e2c42e00a501278ffe80223bada52e2ba269f3 (patch)
treef568c076a58ce277ed2e1f58fc0b767bda19d607 /contrib/pgcrypto
parent0614c5e5fd93bd71a293d7c4e694b06a20c9a70c (diff)
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/pgcrypto')
-rw-r--r--contrib/pgcrypto/expected/init.out6
-rw-r--r--contrib/pgcrypto/sql/init.sql6
2 files changed, 12 insertions, 0 deletions
diff --git a/contrib/pgcrypto/expected/init.out b/contrib/pgcrypto/expected/init.out
index 3252d4276e..6a5710d5a1 100644
--- a/contrib/pgcrypto/expected/init.out
+++ b/contrib/pgcrypto/expected/init.out
@@ -1,7 +1,13 @@
--
-- init pgcrypto
--
+--
+-- first, define the functions. Turn off echoing so that expected file
+-- does not depend on contents of pgcrypto.sql.
+--
+SET client_min_messages = warning;
\set ECHO none
+RESET client_min_messages;
-- check for encoding fn's
SELECT encode('foo', 'hex');
encode
diff --git a/contrib/pgcrypto/sql/init.sql b/contrib/pgcrypto/sql/init.sql
index e536e67ea3..a58b3f0144 100644
--- a/contrib/pgcrypto/sql/init.sql
+++ b/contrib/pgcrypto/sql/init.sql
@@ -2,9 +2,15 @@
-- init pgcrypto
--
+--
+-- first, define the functions. Turn off echoing so that expected file
+-- does not depend on contents of pgcrypto.sql.
+--
+SET client_min_messages = warning;
\set ECHO none
\i pgcrypto.sql
\set ECHO all
+RESET client_min_messages;
-- check for encoding fn's
SELECT encode('foo', 'hex');