Re: [DOCS] Documentation for pgp_pub_decrypt

2016-09-26 Thread Joe Snikeris
Thank you. Your response helped me figure out why pgp_pub_decrypt wasn't working for data that was encrypted outside of pgcrypto. The marker you mention must be added by pgp_pub_encrypt? Perhaps it's worth mentioning in the documentation that pgp_pub_decrypt is only intended be used on data encrypt

Re: [DOCS] Documentation for pgp_pub_decrypt

2016-09-26 Thread Tom Lane
j...@snikeris.com writes: > The following documentation comment has been logged on the website: > Page: https://www.postgresql.org/docs/9.5/static/pgcrypto.html > Description: > I believe the first argument should be of type 'text'. Especially > considering the paragraph that follows discusses how

Re: [DOCS] Documentation for pgp_pub_decrypt

2016-09-26 Thread Kevin Grittner
On Sun, Sep 25, 2016 at 4:55 AM, wrote: > I believe the first argument [apparently of pg_sym_decrypt() and > pg_pub_decrypt()] should be of type 'text'. Especially > considering the paragraph that follows discusses how passing in > bytea is disallowed. The *encrypted* form is bytea; those funct