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

[DOCS] Documentation for pgp_pub_decrypt

2016-09-26 Thread joe
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 passing in bytea is disallowed. -

Re: [DOCS] Undocumented function: has_type_privilege()

2016-09-26 Thread Tom Lane
slang...@fredhutch.org writes: > I have discovered and used the function: > has_type_privilege(type, privilege) > I assume it should be added to the below table, no? > Table 9-58. Access Privilege Inquiry Functions Yeah, must have been an oversight. Added, thanks for the report!