Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjMCI-00053H-Su for pgsql-www@arkaria.postgresql.org; Tue, 15 Jan 2019 10:43:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjMCH-00052T-Bw for pgsql-www@arkaria.postgresql.org; Tue, 15 Jan 2019 10:43:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjMCH-00052L-6K for pgsql-www@lists.postgresql.org; Tue, 15 Jan 2019 10:43:53 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjMCE-0000hb-LD for pgsql-www@postgresql.org; Tue, 15 Jan 2019 10:43:52 +0000 Received: from [38.140.170.58] (helo=Ph33r-Retina.local) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjMCC-0000dm-1e; Tue, 15 Jan 2019 10:43:50 +0000 Subject: Re: mailing list redirect for bug numbers? To: Andres Freund , pgsql-www@postgresql.org References: <20190114221809.eymqah36d6uq5nir@alap3.anarazel.de> From: "Jonathan S. Katz" Openpgp: preference=signencrypt Autocrypt: addr=jkatz@postgresql.org; keydata= mQINBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABtCdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz6JAlQEEwEIAD4CGwMFCQeGH4AFCwkIBwIG FQoJCAsCBBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCW1KJJQAKCRDxBJxy nxxlJwjrD/kBgqsW4QpNpTFw7ifRokZV08CCX4huPBJQ91rrv+UEWlEcotFBHVkYyHnpzARl tcZxhJ9CbFxjniH9cOTty5T/O1yolbOHtZSW8Z8aWV6BVEbjMb+BFxSSLm7RnvJdzQbGCZq2 ZZvfVpB6z3EHYph4KDdVKvMFjoLskxmdS1DE0tE3zTxvoQsi24Q+HOS07kUjs6fsu/WICMfz mgO++AWG9Y0CvN0mm4TkujESzyKM9E5irD+leEMIcddl51Aa2c/VMfBXQbRmpHIgUFTmuHQD CnQih+9i3OJAksDg66SP8a7yiXv5mwvyDi1EfTGVKYR2j+pwyjwnC3oIbvDMmB3uTn2JIjnT iZKPVtAcAylXjubFltihQgNyuShdP4W+kBwZizhUFqUVL8Anx+KoytYmJPfMRFLGuK4obXKq a2ZS3k9KB+H+isOx2nFJOsc7V360Zp1DVaNmuiK10TT6QndShSPaqkJqFtCb6r92rZ9sZM/L 3vtCI4Rrl3Pt1MgtENXupS8gZpJnAYS0j5A1PAZ09r6ANoaeMHspF+5J5fOHeEvqphXr36mm a83Vl1t4orPb0+QmmijmlpseDU63M88Aw5p3c4qj7t8Qr2EZ5zrn7/sFn5wOfbs8Nymxafif QCnlV2vg9p0m7vSk/yLJ4PFZvs52FgqAGRCdRn0s2EC99bkCDQRbUocAARAAv8ho/toQ9DG3 j4f9h9n1aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR 9u6qbOXcdqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq5 0wBW433eTvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAb jX1RiCw9gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSp vfm9eM0uSLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6 x44Wfsx8S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36Z Mroi9XMxg3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+7 0zpKJ10cc7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrd faKZYX2GMZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444X XTuLaP8j2mgcMvYak3ScCykAEQEAAYkCPAQYAQgAJhYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUn BQJbUocAAhsMBQkHhh+AAAoJEPEEnHKfHGUnReMP/RA2UhGQj+G4uBshkRLjpRysabdPqgQB dEBk6wYbio88Wg/2/hgY7UzmDDEwX3sZfQDcrI6+vIobI8uqstZID+WgAAa1JLfChMyVQnSy 0zfWMOABXscc5tGuvFRZvJklTissMFjXUwaREEKp4ZikTvJ/62MCjSdtrUhnPLvoTsHTKRKD ichE+b5A54alwsubTijw12O6N22r5IjZiiSZV0u7dsShyKw+7wCSax9fuBoE43NMYf+dnjMK nerAQYUcZWYMnk+EC8RaqYAxv6XZ2tKx1AkGGktwkQIBwrz9IlDSvJ3LWJ2UIIuLRTdngNgg GIL4zzuUa2F56FqskQIuYMaNETk6LYfalBDQ6TVLAcgCPQxp4k4i/PRsZ3lZ2ZhRHRYciOvm kp+I6EfHwllQpYrWs1thluBGqlJSVJgKl0IOFvKLsQ6KKfqzAwh6FxrO5qajp4viNIgtWoFw O5Bp0jgFTbH2OrMWIRfUdUCH1Djbuo65svhNj7FNsQVYzHDI+Nd1I/LOBoPc3UorRMF2M4JV kUR7skOHWUbPTSNUr7qc14NSMY3PKjGeVGAsBVHBPvmRx/Ss2tW/TpJWpxg4pmquFQSXuaYh Yf4FN8Sxy320pcr+FqN8AhZkYJcNY82OTtR5VEKRC/mYcyq61qXIKqngydn79bJjGxHipxyF FmEC Message-ID: <9cfc2880-0623-7cc3-45f4-342c3af881fe@postgresql.org> Date: Tue, 15 Jan 2019 05:43:44 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: <20190114221809.eymqah36d6uq5nir@alap3.anarazel.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="P9LyNJDGXEp4vHX8snCAc07rVwaiFIArY" X-Host-Lookup-Failed: Reverse DNS lookup failed for 38.140.170.58 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --P9LyNJDGXEp4vHX8snCAc07rVwaiFIArY Content-Type: multipart/mixed; boundary="eB6ACJ8D0cQikcer1rd6qBq109W5XqvTN"; protected-headers="v1" From: "Jonathan S. Katz" To: Andres Freund , pgsql-www@postgresql.org Message-ID: <9cfc2880-0623-7cc3-45f4-342c3af881fe@postgresql.org> Subject: Re: mailing list redirect for bug numbers? References: <20190114221809.eymqah36d6uq5nir@alap3.anarazel.de> In-Reply-To: <20190114221809.eymqah36d6uq5nir@alap3.anarazel.de> --eB6ACJ8D0cQikcer1rd6qBq109W5XqvTN Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable Hi Andres, On 1/14/19 5:18 PM, Andres Freund wrote: > Hi, >=20 > How hard would it be to have a redirect similar to > https://www.postgresql.org/message-id/ >=20 > 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 lis= t > to pgsql-bugs, and the prefix to "BUG #" or such. The bug ID numbers are generated from pgweb using: SELECT nextval('bug_id_seq') And then prefixed to the email thread as per the above. More on this in a second. > Or perhaps > there's a database table with bugs -> messageid mappings somewhere? Or > could be created using a query like the above? IMV that would be an excellent suggestion. My guess is in order to make that work, we would create the mapping when the initial bug report makes it into the archives. > 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. Agreed, that sounds like a nicer UX. The only big catch I see is that if someone emails -bugs directly, no number is assigned, so we would have to leave that be. I don't know if we would want to use "/message-id/" as the parent URL, just in case someone sent a message with an ID of just digits (for whatever reason). Dare I suggest something like "/bugs//?" Assuming buy-in, what would need to be done is: - Adjust the message import script to parse inbound messages with above message beginning to -bugs. Determine if it is the first message to the thread / bug ID is already registered. If it does not exist, record the bug ID, message ID combo in a new table - Write a one time script to map old bug id to first message id in the thread. - Update the urls.py in pgarchives to handle said route and fail gracefully if bug ID does not exist - Note in pgweb where the email is generated that any changes to email subject could break things. And that should be that. Thoughts? Jonathan --eB6ACJ8D0cQikcer1rd6qBq109W5XqvTN-- --P9LyNJDGXEp4vHX8snCAc07rVwaiFIArY Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlw9uWAACgkQ8QSccp8c ZSdhjA/7BFx+kuVOeVGn3SfnE3jXHaMmeLaRr0f4bXvzXKCIVesJCizECzwol8c8 LGSVrD0tBvyinnHbMcM9Ly+eqVZsabjfk6qGB8/+SfyjGpzX71i7qBHfBHDYlzbg 2rCKFbjjfoXyCoKEuuQlR7qMAzPayEDBFojD7+9UsiHwzhPentEJkt5/bVXS47pW kliQ+eZfQ0BMgBTBg5maQv2tihxv8kqR8nzQQIhMJbvPnFnSDoIk/ZI4ijW2NEVO Z6GqrPybZZHtjqAiZI+ibU9Xi5yRVn2CJA0nUDuAzGLM2An7V8poTHq6AmbAQmY9 7rnWXoL+WG7C4ugvnkfzW7GL6cA3J+kMtr7R3DJ6A2sUFbsounPqyaVjYidojxFA XcqzW5V7g7NBg8q30bciMOTC8Si3gwz4YoOLgRPrixOl4/lBBo6iTQME59CngQ31 LeOYUoAl1C4EVynrqid0NTXC3p9uJcgXSNkBUd0lOwvM6ZRSPZw85jPLeNiRalSq PVC9JCa7LRPE80xf+9HRGXnSu175WCrT/4ZNbQxdmOs2PAX/SS0l9rzzMCvQ6fkA 2lRoNtZH+xrQbFhQqFm2559nOUoQt2C6GTJzCTaxrE7MzxUiWFF1UzWdzcmFX5sj 6vudahQNQ5zbY6WjiJ57RR7FNOKE84F66di3kXcDYZZfMIeOIBg= =UP/C -----END PGP SIGNATURE----- --P9LyNJDGXEp4vHX8snCAc07rVwaiFIArY--