MIME-Version: 1.0
References: <20190116195327.GF2528@tamriel.snowman.net>
 <201901162154.tg6vsmfylacs@alvherre.pgsql>
 <20190116215607.3bfswn4syewmncix@alap3.anarazel.de>
In-Reply-To: <20190116215607.3bfswn4syewmncix@alap3.anarazel.de>
From: Magnus Hagander <magnus@hagander.net>
Date: Thu, 17 Jan 2019 10:33:49 +0100
Message-ID: 
 <CABUevEwmfsPorfqscJqNtRYiyLUAHTGw5UFzgDMkvk=aEc_c9w@mail.gmail.com>
Subject: Re: mailing list redirect for bug numbers?
To: Andres Freund <andres@anarazel.de>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
 Stephen Frost <sfrost@snowman.net>,
	"Jonathan S. Katz" <jkatz@postgresql.org>,
 PostgreSQL WWW <pgsql-www@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000029f00c057fa418a1"
Precedence: bulk

--00000000000029f00c057fa418a1
Content-Type: text/plain; charset="UTF-8"

On Wed, Jan 16, 2019 at 10:56 PM Andres Freund <andres@anarazel.de> wrote:

> On 2019-01-16 18:54:40 -0300, Alvaro Herrera wrote:
> > On 2019-Jan-16, Stephen Frost wrote:
> >
> > > As I recall, we actively discussed doing something similar for
> -hackers,
> > > to shorten up the URLs going into commit messages but there was some
> > > concern over having a mapping from IDs to message-IDs.  I'd have to go
> > > dig up the thread to remember what the issue was there.
> >
> > The issue is that people working offline want to be able to figure out
> > emails in their local mailboxes looking just at the contents of a commit
> > message.  This is trivial if the URLs contain the message-id, and
> > impossible if they don't.
> >
> > With bug numbers, the situation is the same: if, while offline, you have
> > a commit message carrying a bug number, and an offline mailbox where
> > pgsql-bugs threads are tagged with the same bug numbers, it's easy to
> > look up the thread based only on the contents of the commit message.  If
> > you have to contact a web interface to figure out what the thread is,
> > that workflow fails.
> >
> > Based on this, my opinion is that a redirection system that handles
> >   https://postgr.es/bug/8470
> > by redirecting to message
> >   https://postgr.es/m/E1VOpEt-0003nc-4J@wrigleys.postgresql.org
> > works fine, because I can look up the thread by looking for the bug
> > number in the subject.  If we do anything more complicated than that
> > (say a database filled with message-ids based on bug IDs that don't
> > appear in the message subject), that workflow fails when I'm offline.
>
> Well said.
>

Definitely agreed. The current bug assignment system is trivial for a
reason, let's keep it that way. If what we want is a bugtracker we should
have that instead, but hey, that's definitely out of scope and let's not
open that can of worms today.

I've added a patch to start tracking the bugid<->messageid mapping on new
bugs. There's no using it yet, but at least we track for the future. Next
step is backfill, and after that we can start stitching the pieces together.

-- 
 Magnus Hagander
 Me: https://www.hagander.net/ <http://www.hagander.net/>
 Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

--00000000000029f00c057fa418a1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Jan 16, 2019 at 10:56 PM Andres F=
reund &lt;<a href=3D"mailto:andres@anarazel.de">andres@anarazel.de</a>&gt; =
wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex">On 2019-01-16 18:54:40 -0300, Alvaro Herrera wrote:<br>
&gt; On 2019-Jan-16, Stephen Frost wrote:<br>
&gt; <br>
&gt; &gt; As I recall, we actively discussed doing something similar for -h=
ackers,<br>
&gt; &gt; to shorten up the URLs going into commit messages but there was s=
ome<br>
&gt; &gt; concern over having a mapping from IDs to message-IDs.=C2=A0 I=
9;d have to go<br>
&gt; &gt; dig up the thread to remember what the issue was there.<br>
&gt; <br>
&gt; The issue is that people working offline want to be able to figure out=
<br>
&gt; emails in their local mailboxes looking just at the contents of a comm=
it<br>
&gt; message.=C2=A0 This is trivial if the URLs contain the message-id, and=
<br>
&gt; impossible if they don&#39;t.<br>
&gt; <br>
&gt; With bug numbers, the situation is the same: if, while offline, you ha=
ve<br>
&gt; a commit message carrying a bug number, and an offline mailbox where<b=
r>
&gt; pgsql-bugs threads are tagged with the same bug numbers, it&#39;s easy=
 to<br>
&gt; look up the thread based only on the contents of the commit message.=
=C2=A0 If<br>
&gt; you have to contact a web interface to figure out what the thread is,<=
br>
&gt; that workflow fails.<br>
&gt; <br>
&gt; Based on this, my opinion is that a redirection system that handles<br=
>
&gt;=C2=A0 =C2=A0<a href=3D"https://postgr.es/bug/8470" rel=3D"noreferrer" =
target=3D"_blank">https://postgr.es/bug/8470</a><br>
&gt; by redirecting to message<br>
&gt;=C2=A0 =C2=A0<a href=3D"https://postgr.es/m/E1VOpEt-0003nc-4J@wrigleys.=
postgresql.org" rel=3D"noreferrer" target=3D"_blank">https://postgr.es/m/E1=
VOpEt-0003nc-4J@wrigleys.postgresql.org</a><br>
&gt; works fine, because I can look up the thread by looking for the bug<br=
>
&gt; number in the subject.=C2=A0 If we do anything more complicated than t=
hat<br>
&gt; (say a database filled with message-ids based on bug IDs that don&#39;=
t<br>
&gt; appear in the message subject), that workflow fails when I&#39;m offli=
ne.<br>
<br>
Well said.<br>
</blockquote></div><div><br></div><div>Definitely agreed. The current bug a=
ssignment system is trivial for a reason, let&#39;s keep it that way. If wh=
at we want is a bugtracker we should have that instead, but hey, that&#39;s=
 definitely out of scope and let&#39;s not open that can of worms today.</d=
iv><div><br></div><div>I&#39;ve added a patch to start tracking the bugid&l=
t;-&gt;messageid mapping on new bugs. There&#39;s no using it yet, but at l=
east we track for the future. Next step is backfill, and after that we can =
start stitching the pieces together.</div><div><br></div>-- <br><div dir=3D=
"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>=C2=A0Magnus Hagander=
<br>=C2=A0Me: <a href=3D"http://www.hagander.net/" target=3D"_blank">https:=
//www.hagander.net/</a><br>=C2=A0Work: <a href=3D"http://www.redpill-linpro=
.com/" target=3D"_blank">https://www.redpill-linpro.com/</a></div></div></d=
iv></div>

--00000000000029f00c057fa418a1--