diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-10 13:46:29 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-10 13:46:29 +0000 |
| commit | e94dd6ab9100961511e3407fea9e5b191dec7165 (patch) | |
| tree | 996841b24c245441daa2dc5b1476dce0294e5bd9 /contrib/pgcrypto/sql/pgp-compression.sql | |
| parent | 42e7b0f02fe1975a03853190bd9211a6faf22c84 (diff) | |
| download | postgresql-e94dd6ab9100961511e3407fea9e5b191dec7165.tar.gz | |
Add missing pgcrypto files from previous commit.
Diffstat (limited to 'contrib/pgcrypto/sql/pgp-compression.sql')
| -rw-r--r-- | contrib/pgcrypto/sql/pgp-compression.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/contrib/pgcrypto/sql/pgp-compression.sql b/contrib/pgcrypto/sql/pgp-compression.sql new file mode 100644 index 0000000000..f71c176da5 --- /dev/null +++ b/contrib/pgcrypto/sql/pgp-compression.sql @@ -0,0 +1,31 @@ +-- +-- PGP compression support +-- + +select pgp_sym_decrypt(dearmor(' +-----BEGIN PGP MESSAGE----- + +ww0ECQMCsci6AdHnELlh0kQB4jFcVwHMJg0Bulop7m3Mi36s15TAhBo0AnzIrRFrdLVCkKohsS6+ +DMcmR53SXfLoDJOv/M8uKj3QSq7oWNIp95pxfA== +=tbSn +-----END PGP MESSAGE----- +'), 'key', 'expect-compress-algo=1'); + +select pgp_sym_decrypt( + pgp_sym_encrypt('Secret message', 'key', 'compress-algo=0'), + 'key', 'expect-compress-algo=0'); + +select pgp_sym_decrypt( + pgp_sym_encrypt('Secret message', 'key', 'compress-algo=1'), + 'key', 'expect-compress-algo=1'); + +select pgp_sym_decrypt( + pgp_sym_encrypt('Secret message', 'key', 'compress-algo=2'), + 'key', 'expect-compress-algo=2'); + +-- level=0 should turn compression off +select pgp_sym_decrypt( + pgp_sym_encrypt('Secret message', 'key', + 'compress-algo=2, compress-level=0'), + 'key', 'expect-compress-algo=0'); + |