summaryrefslogtreecommitdiff
path: root/contrib/pgcrypto/sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/pgcrypto/sql')
-rw-r--r--contrib/pgcrypto/sql/blowfish.sql2
-rw-r--r--contrib/pgcrypto/sql/crypt-blowfish.sql2
-rw-r--r--contrib/pgcrypto/sql/crypt-des.sql2
-rw-r--r--contrib/pgcrypto/sql/crypt-md5.sql2
-rw-r--r--contrib/pgcrypto/sql/crypt-xdes.sql2
-rw-r--r--contrib/pgcrypto/sql/hmac-md5.sql2
-rw-r--r--contrib/pgcrypto/sql/hmac-sha1.sql2
-rw-r--r--contrib/pgcrypto/sql/init.sql1
-rw-r--r--contrib/pgcrypto/sql/md5.sql2
-rw-r--r--contrib/pgcrypto/sql/rijndael.sql2
-rw-r--r--contrib/pgcrypto/sql/sha1.sql2
11 files changed, 0 insertions, 21 deletions
diff --git a/contrib/pgcrypto/sql/blowfish.sql b/contrib/pgcrypto/sql/blowfish.sql
index 93187dcba3..e5f6ddccf3 100644
--- a/contrib/pgcrypto/sql/blowfish.sql
+++ b/contrib/pgcrypto/sql/blowfish.sql
@@ -2,8 +2,6 @@
-- Blowfish cipher
--
-SET autocommit TO 'on';
-
-- some standard Blowfish testvalues
SELECT encode(encrypt(
decode('0000000000000000', 'hex'),
diff --git a/contrib/pgcrypto/sql/crypt-blowfish.sql b/contrib/pgcrypto/sql/crypt-blowfish.sql
index 5128675e0c..effc186620 100644
--- a/contrib/pgcrypto/sql/crypt-blowfish.sql
+++ b/contrib/pgcrypto/sql/crypt-blowfish.sql
@@ -2,8 +2,6 @@
-- crypt() and gen_salt(): bcrypt
--
-SET autocommit TO 'on';
-
SELECT crypt('', '$2a$06$RQiOJ.3ELirrXwxIZY8q0O');
SELECT crypt('foox', '$2a$06$RQiOJ.3ELirrXwxIZY8q0O');
diff --git a/contrib/pgcrypto/sql/crypt-des.sql b/contrib/pgcrypto/sql/crypt-des.sql
index ff43112dd8..b13d2f9de7 100644
--- a/contrib/pgcrypto/sql/crypt-des.sql
+++ b/contrib/pgcrypto/sql/crypt-des.sql
@@ -2,8 +2,6 @@
-- crypt() and gen_salt(): crypt-des
--
-SET autocommit TO 'on';
-
SELECT crypt('', 'NB');
SELECT crypt('foox', 'NB');
diff --git a/contrib/pgcrypto/sql/crypt-md5.sql b/contrib/pgcrypto/sql/crypt-md5.sql
index c570e4ab7a..0002f0d34d 100644
--- a/contrib/pgcrypto/sql/crypt-md5.sql
+++ b/contrib/pgcrypto/sql/crypt-md5.sql
@@ -2,8 +2,6 @@
-- crypt() and gen_salt(): md5
--
-SET autocommit TO 'on';
-
SELECT crypt('', '$1$Szzz0yzz');
SELECT crypt('foox', '$1$Szzz0yzz');
diff --git a/contrib/pgcrypto/sql/crypt-xdes.sql b/contrib/pgcrypto/sql/crypt-xdes.sql
index c6205ab600..51271dba6d 100644
--- a/contrib/pgcrypto/sql/crypt-xdes.sql
+++ b/contrib/pgcrypto/sql/crypt-xdes.sql
@@ -2,8 +2,6 @@
-- crypt() and gen_salt(): extended des
--
-SET autocommit TO 'on';
-
SELECT crypt('', '_J9..j2zz');
SELECT crypt('foox', '_J9..j2zz');
diff --git a/contrib/pgcrypto/sql/hmac-md5.sql b/contrib/pgcrypto/sql/hmac-md5.sql
index ed2b65b7b8..70bef7cd50 100644
--- a/contrib/pgcrypto/sql/hmac-md5.sql
+++ b/contrib/pgcrypto/sql/hmac-md5.sql
@@ -2,8 +2,6 @@
-- HMAC-MD5
--
-SET autocommit TO 'on';
-
SELECT encode(hmac(
'Hi There',
decode('0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b', 'hex'),
diff --git a/contrib/pgcrypto/sql/hmac-sha1.sql b/contrib/pgcrypto/sql/hmac-sha1.sql
index fb70424dce..4adf6ed086 100644
--- a/contrib/pgcrypto/sql/hmac-sha1.sql
+++ b/contrib/pgcrypto/sql/hmac-sha1.sql
@@ -2,8 +2,6 @@
-- HMAC-MD5
--
-SET autocommit TO 'on';
-
SELECT encode(hmac(
'Hi There',
decode('0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b', 'hex'),
diff --git a/contrib/pgcrypto/sql/init.sql b/contrib/pgcrypto/sql/init.sql
index 08ffeb4981..9d38cb5854 100644
--- a/contrib/pgcrypto/sql/init.sql
+++ b/contrib/pgcrypto/sql/init.sql
@@ -3,7 +3,6 @@
--
\set ECHO none
-SET autocommit TO 'on';
\i pgcrypto.sql
\set ECHO all
diff --git a/contrib/pgcrypto/sql/md5.sql b/contrib/pgcrypto/sql/md5.sql
index 0c851217b2..d6e502779a 100644
--- a/contrib/pgcrypto/sql/md5.sql
+++ b/contrib/pgcrypto/sql/md5.sql
@@ -2,8 +2,6 @@
-- MD5 message digest
--
-SET autocommit TO 'on';
-
SELECT encode(digest('', 'md5'), 'hex');
SELECT encode(digest('a', 'md5'), 'hex');
SELECT encode(digest('abc', 'md5'), 'hex');
diff --git a/contrib/pgcrypto/sql/rijndael.sql b/contrib/pgcrypto/sql/rijndael.sql
index 793b07f362..6f3dfc9622 100644
--- a/contrib/pgcrypto/sql/rijndael.sql
+++ b/contrib/pgcrypto/sql/rijndael.sql
@@ -2,8 +2,6 @@
-- AES / Rijndael-128 cipher
--
-SET autocommit TO 'on';
-
-- some standard Rijndael testvalues
SELECT encode(encrypt(
decode('00112233445566778899aabbccddeeff', 'hex'),
diff --git a/contrib/pgcrypto/sql/sha1.sql b/contrib/pgcrypto/sql/sha1.sql
index 1c0fcd9072..6a398b411e 100644
--- a/contrib/pgcrypto/sql/sha1.sql
+++ b/contrib/pgcrypto/sql/sha1.sql
@@ -2,8 +2,6 @@
-- SHA1 message digest
--
-SET autocommit TO 'on';
-
SELECT encode(digest('', 'sha1'), 'hex');
SELECT encode(digest('a', 'sha1'), 'hex');
SELECT encode(digest('abc', 'sha1'), 'hex');