Corrupt Data error in Decryption in PostgreSQL using GnuPG

[periwalridhi]

I am using GnuPG software for assymetric encryption in PostgreSQL.
I have done encryption using

->INSERT INTO "test1"("test") 
 ->   VALUES (pgp_pub_encrypt('testing', dearmor('------>BEGIN PGP PUBLIC KEY BLOCK-----
->Version: GnuPG v2.0.17 (MingW32)
 
->..............
->-----END PGP PUBLIC KEY BLOCK-----'
 
->)));

and got succeded

but when i am doing decryption with syntax:-

->SELECT pgp_pub_decrypt(bytea ("test"),
->dearmor('-----BEGIN PGP PRIVATE KEY BLOCK-----
->Version: GnuPG v2.0.17 (MingW32)
->.............................
->-----END PGP PRIVATE KEY BLOCK-----'),'decrypt123')  --> ->this is the passphrase 
 -> FROM "test1"; 

I am getting error as:-

->ERROR: Corrupt data

->********** Error **********

->ERROR: Corrupt data
->SQL state: 39000



Please guide me where i am going wrong..as i need this urgently

[Rabbit]

Please use code tags when posting code.

This is from the PostgreSQL manual: Decrypting bytea data with pgp_pub_decrypt is disallowed. This is to avoid outputting invalid character data.

[periwalridhi]

I have even tried with pgp_pub_decrypt_bytea but am getting same erorr..please help..

[Rabbit]

It could be that the public key and secret key you're using is out of sync. Try generating new pairs and using those. Or it could be that the password you're using for the secret key is wrong. It's hard to say because the error is so generic.

[periwalridhi]

I regenerated the keys and even used the correct passphrase. I am still getting this error. Am i using the correct approach for public key encryption? Do i need to write some extra code for making decryption successful?
please help.

[Rabbit]

Sorry, I haven't used that function much. Hopefully there's someone here with more experience with that.

[periwalridhi]

Its ok and thanx for your help. I got success after making keys passwrdless. After removing passphrase column,decryption is successful.