diff options
Diffstat (limited to 'contrib/pgcrypto/sql')
| -rw-r--r-- | contrib/pgcrypto/sql/blowfish.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/crypt-blowfish.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/crypt-des.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/crypt-md5.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/crypt-xdes.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/hmac-md5.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/hmac-sha1.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/init.sql | 1 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/md5.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/rijndael.sql | 2 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/sha1.sql | 2 |
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'); |
