Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvXaY-00F9Si-MH for pgsql-www@arkaria.postgresql.org; Mon, 08 Sep 2025 08:51:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uvXaX-003B1i-Kk for pgsql-www@arkaria.postgresql.org; Mon, 08 Sep 2025 08:51:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvXaX-003Az7-9y for pgsql-www@lists.postgresql.org; Mon, 08 Sep 2025 08:51:01 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uvXaV-0017w8-2i for pgsql-www@lists.postgresql.org; Mon, 08 Sep 2025 08:51:00 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-e96f401c478so3198972276.3 for ; Mon, 08 Sep 2025 01:50:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hagander.net; s=mail; t=1757321459; x=1757926259; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=cyvQ5hsz+ACXDgiOSRV1lJjOmBcwkK372dqL4RpQkkI=; b=DnxrRnK58IHXF3TJZ9efUtV8mO1E3y7Gr3e4DUGRIxfGZRvz94lbX6Xxz0z7iwjsCH uXj7FG+QkPceeW9AYkFeH6MrV51ZA6w7cPWw14XMwCCBUYcnKE10bw1Dbv/oX/IpQBgD N9gga52HlNTPN3pL7tZDo6RTUlDWIpKvUFwCxm/HPSKiCmIbCULeqrcU13/ffgeuXlAv eEYwPjeTo5qfor1s6v8A0vUI8VrPukF1ghLYkWyIsJK63UfFNl+s55QnRXxQqKEIQi8e +GHBhdtM7raav0vDPvXX9O006RrzpzietgLFLLOFr0ortdfuQGtNE5qjiVN9PGF0NaSM kOPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757321459; x=1757926259; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=cyvQ5hsz+ACXDgiOSRV1lJjOmBcwkK372dqL4RpQkkI=; b=EDQTN5ZRy1vXik04RpoaxHGIzERmWo6SbpdO1dtbuFxHYIRCzszFCTsGjq7wG0BRIB IvJOVcLbCogaIvC79GPngzuDBewCv4uYibgJ4wcLXWH4oulaW6jKuI8AW19bOzFsKo+e +OZJ+Ce4rrX++KDHWTJWVNof/PMMat5kgburcIp6AsJuMFRIOzbLVSw52HwHBnZeljF7 2nl06+nFcW1oQ/7CTQQxdTsuE6sAAQQyJZBWaJFHvioapCG9qZoTLHzsmiTW6ZrhkNQe HSc9m7dE1wdrQpSuIT8DQZdeH+LEMJZbqgqS0D88rbjG0TFfXTbimQB5xmhvSRiuyp35 WKkw== X-Forwarded-Encrypted: i=1; AJvYcCUypvlJnygsJwrzVTuer4jj3uqqHIvZ2UP8B2a8Vjqs9w82CYUP8+Q+QzWD+Irc5TZf0YUcEYgHbAw=@lists.postgresql.org X-Gm-Message-State: AOJu0Yzx0i1zeUbsYdJnMLFThpWFgImLW3OGqH7VrC0lW1NEIgooZJlb wRGm+ByYOrb7v2ravyY7V5rRIL5J1Qj/iwYEMReS/hCXnagS+Fd1WHXQXKuQEiStAHC/QcIOeH7 CYTLn7IUQPxyOEUv9E112oUSRFQ2BvKrRlCEPHF/P X-Gm-Gg: ASbGncsg2erh8sYwHZjNmrKL3/HAlWyZ1wp3THnYzgZMXpT7Bf/cuz3yVkPs5nRjvzi oSshRRXZdOP1TLsY8IbQdX6T+DJ7gukfhRul05UTTxjQzhvVmf1tmUv5X14Hh0k55SmTLQK5igW 63IAVpBcYzrX87sYGabWelbav+QwxhrYC2R82YaB2kX8bZNrM/PGYIzxNagyvtRaEe5u9LUO7Q8 InM64U= X-Google-Smtp-Source: AGHT+IG2SsrNwU2oVipPkLLWaGWXOkGeF85fhhl02piJ2nhS7OM50tpitimIPjLq+TDaM5bgwYg5CfWvdPO4SAX/5BY= X-Received: by 2002:a05:6902:1544:b0:e9d:6ff4:fc9b with SMTP id 3f1490d57ef6-e9f689a585cmr5859467276.46.1757321458949; Mon, 08 Sep 2025 01:50:58 -0700 (PDT) MIME-Version: 1.0 References: <99A6E7C8-1634-4162-96FD-D5AC404ADBCF@gmx.net> <29c71778-5871-4e4d-a80e-d67351c8eb4b@postgresql.org> <4C210077-20E5-415C-8A69-B82331A42B9A@gmx.net> In-Reply-To: <4C210077-20E5-415C-8A69-B82331A42B9A@gmx.net> From: Magnus Hagander Date: Mon, 8 Sep 2025 10:50:46 +0200 X-Gm-Features: AS18NWAgNM_iJcVK-rG_OpZ_aY-2LOt9hmr3qIR-WA_OosneG13QDZZPSITx9LA Message-ID: Subject: Re: Images in news mails To: Tobias Bussmann Cc: "Jonathan S. Katz" , pgsql-www@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000513d6e063e464906" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000513d6e063e464906 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Sep 7, 2025 at 6:16=E2=80=AFPM Tobias Bussmann = wrote: > Am 05.09.2025 um 20:23 schrieb Jonathan S. Katz : > > This has plagued me for years, and I'm so happy you tracked this down! > > I'm happy to hear, I'm not the only one seeing this. Glad to help! > What's more amazing is that AFAIK this is the first time *anyone* has reported this to be a problem. And it's been this way since 2020... It is also slightly ironic that it's apple mail that's seeing the problem, given it's quite overrepresented in *generating* broken attachments in similar ways when you look in the archive :) > The patch looks good; have you tested in a few other mail clients? I > haven't had a chance to test yet. > > I haven't tried other mail clients myself, but as the style definition is > just redundant to the img attributes, I wouldn't expect any regression by > this. But HTML emails are full of miracles ;) > Indeed it does. For example, you mentioned the possibility of embedding the image instead of attaching - that *does* break multiple clients, I think at least Outlook and maybe also gmail. > Litmus.com has become quite expensive for render previews, so I looked fo= r > alternatives. I found Testi.at, which offers some free tests at least. > Unfortunately, I was unable to provide the full MIME structure there and > thus could not simulate the CID-referenced image that causes the problem = in > Apple Mail. When I experimented with an externally hosted image, the resu= lt > looked good in the provided previews. However, I visually identified > another issue: Outlook does not seem to support the 'float' style attribu= te > [1 footnote 1]. In the v2 patch, I implemented a workaround to duplicate > the 'float' style using an 'align' img attribute. Previews of the resulti= ng > rendering can be found at [2]. > > PGEU does have a subscription to a service that could be used for testing. We'd need to adapt the test instance of the website for it, but that's fairly easy to do. I'll also see if I can dig out my old notes for how we ended up in this stricture in the first place, because it did go back and forth a bunch before actually merged. //Magnus --000000000000513d6e063e464906 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Sun, Sep 7, = 2025 at 6:16=E2=80=AFPM Tobias Bussmann <t.bussmann@gmx.net> wrote:
Am 05.09.2025 um 20:23 schrieb Jonathan S. Katz &l= t;jkatz@postgresq= l.org>:
> This has plagued me for years, and I'm so happy you tracked this d= own!

I'm happy to hear, I'm not the only one seeing this. Glad to help!<= br>

What's more amazing is that AFAIK t= his is the first time *anyone* has reported this to be a problem. And it= 9;s been this way since 2020...

It is also slightl= y ironic that it's apple mail that's seeing the problem, given it&#= 39;s quite overrepresented in *generating* broken attachments in similar wa= ys when you look in the archive :)


> The patch looks good; have you tested in a few other mail clients? I h= aven't had a chance to test yet.

I haven't tried other mail clients myself, but as the style definition = is just redundant to the img attributes, I wouldn't expect any regressi= on by this. But HTML emails are full of miracles ;)
Indeed it does. For example, you mentioned the=C2=A0possibilit= y of embedding the image instead of attaching - that *does* break multiple = clients, I think at least Outlook and maybe also gmail.



Litmus.com has become quite expensive for render previews, so I looked for = alternatives. I found Testi.at, which offers some free tests at least. Unfo= rtunately, I was unable to provide the full MIME structure there and thus c= ould not simulate the CID-referenced image that causes the problem in Apple= Mail. When I experimented with an externally hosted image, the result look= ed good in the provided previews. However, I visually identified another is= sue: Outlook does not seem to support the 'float' style attribute [= 1 footnote 1]. In the v2 patch, I implemented a workaround to duplicate the= 'float' style using an 'align' img attribute. Previews of = the resulting rendering can be found at [2].


<= /div>
PGEU does have a subscription to a service that could be used for= testing. We'd need to adapt the test instance of the website for it, b= ut that's fairly easy to do.

I'll also see= if I can dig out my old notes for how we ended up in this stricture in the= first place, because it did go back and forth a bunch before actually merg= ed.

//Magnus
=C2=A0
--000000000000513d6e063e464906--