Re: [HACKERS] pgbench - allow to store select results into variables

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] pgbench - allow to store select results into variables
Date: 2018-08-14 11:38:21
Message-ID: alpine.DEB.2.21.1808141307140.27691@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hello Andrew,

> It's not done by my MUA, and it's present in your latest posted patch. If
> anything I'd suspect your MUA:
> andrew(at)emma*$ curl -s

Argh. Indeed, this downloaded version has CRLF. Now when I save the
attachment in my MUA, I only have LF... Let us look at the raw format:

Content-Type: text/plain; name=pgbench-into-19.patch
Content-Transfer-Encoding: BASE64


Where you immediatly see that it has indeed CRLF at the end of the second

So you are right, and my trusted mailer is encoding *AND* decoding

Why would it do that? After some googling, this is because RFC 2046 (MIME)
says you "MUST":

So I'm right in the end, and the whole world is wrong, which is a

As I cannot except everybody to have a RFC 2046 compliant MUA, and after
some meddling in "/etc/mime.types", I now have:

Content-Type: application/octet-stream; name=pgbench-into-19.patch
Content-Transfer-Encoding: BASE64


Which is much better:-)

I re-attached the v19 for a check on the list.


Attachment Content-Type Size
pgbench-into-19.patch application/octet-stream 25.4 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2018-08-14 11:49:02 Re: Problem while updating a foreign table pointing to a partitioned table on foreign server
Previous Message Andrew Gierth 2018-08-14 11:37:16 Re: [HACKERS] pgbench - allow to store select results into variables