Re: psql history vs. dearmor (pgcrypto)

Robert Haas <robertmhaas@gmail.com>

View thread

From: Robert Haas <robertmhaas@gmail.com>

To: Tomas Vondra <tv@fuzzy.cz>

Cc: pgsql-hackers@postgresql.org

Date: 2011-11-14T18:01:28Z

Lists: pgsql-hackers

Attachments

save-empty-lines.patch (application/octet-stream) patch

2011/11/13 Tomas Vondra <tv@fuzzy.cz>:
> but recalling it from the query buffer results in
>
>  ERROR:  Corrupt ascii-armor
>
> I've noticed this on 9.1 but 9.2devel behaves exactly the same. I'm
> using 64-bit Linux with UTF8, nothing special.

It looks like the problem is that the original has a blank line after
the line that says "Version: GnuPG v2.0.17 (GNU/Linux)", but when you
recall it from the query buffer, that extra blank line gets elided.

The attached patch fixes it for me.  I'm a little worried it might
cause a problem in some case I'm not thinking about, but I can't think
of any such case right this minute.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company