Date: Mon, 14 Jan 2019 14:18:09 -0800
From: Andres Freund <andres@anarazel.de>
To: pgsql-www@postgresql.org
Subject: mailing list redirect for bug numbers?
Message-ID: <20190114221809.eymqah36d6uq5nir@alap3.anarazel.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Precedence: bulk

Hi,

How hard would it be to have a redirect similar to
https://www.postgresql.org/message-id/<id>

that accepted bug numbers instead of message ids?  I don't know the
precise database schema of the archives, but I assume it could be done
with a prefix query that filters the sender to @postgresql.org, the list
to pgsql-bugs, and the prefix to "BUG #<bugno>" or such.  Or perhaps
there's a database table with bugs -> messageid mappings somewhere? Or
could be created using a query like the above?

It'd be neat to link to bugs from commit messages in a clearer format
(i.e. to the bug number, rather than it being one of potentially
multiple message ids), and it also makes manual lookup nicer.

Greetings,

Andres Freund