On 11/7/09, Christian Petzold <C.Petzold@xxxxxxx> wrote: > I'm trying to use the pgp_pub_encrypt and pgp_pub_decrypt_bytea functions > to store some data in my db. > > This is how I encrypt: > > INSERT INTO "Test"( > "test") > VALUES (pgp_pub_encrypt('test', dearmor('-----BEGIN PGP PUBLIC KEY > BLOCK----- > Version: GnuPG v2.0.12 (MingW32) > > mQENBErk2KkBCAC.... (public key block) ... > -----END PGP PUBLIC KEY BLOCK----- > '))); > > And this is how I try to decrypt: > > SELECT pgp_pub_decrypt_bytea(bytea ("test"), dearmor('-----BEGIN PGP > PRIVATE KEY BLOCK----- > Version: GnuPG v2.0.12 (MingW32) > > lQO+BErk2KkBC... (private key block) ... > -----END PGP PRIVATE KEY BLOCK----- > '), 'ktulu3437') --> this is the passphrase > FROM "Test"; > > Encryptions works fine, but the decrypting returns "Corrupt data". > What am I doing wrong? - if this is the SQL you test with, make sure the table is empty... - this message may also appear if the passphrase for secret key is wrong. [this needs fixing] - make sure the secret key really corresponds to public key If none of these fix your problem, please send repeatable test-case (with temp key). -- marko -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general