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 1gjtAZ-0005yQ-Q2 for pgsql-www@arkaria.postgresql.org; Wed, 16 Jan 2019 21:56:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjtAY-0004Wc-Ir for pgsql-www@arkaria.postgresql.org; Wed, 16 Jan 2019 21:56:18 +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 1gjtAW-0004WV-QP for pgsql-www@lists.postgresql.org; Wed, 16 Jan 2019 21:56:18 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjtAS-0003gv-C0; Wed, 16 Jan 2019 21:56:16 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 5E55028C3C; Wed, 16 Jan 2019 16:56:10 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Wed, 16 Jan 2019 16:56:10 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=SsR/P7emwZmkSEddHwTr+5rSEK0 NGdVTZtmn9vekkXg=; b=ZTmCrCxna92EjjtdPXzDO2hDgy9vBpZl7OQv2jGSqbp +qkY8ybt0cMwWV+TFsgvqrx1/FcnAGe3BAefPaomzdrB0nV408G8o0gLGg0g4iYC iWZXEJe2w+4WnmEaAkmzzNWG6j3sdzpn1Ual7VxKNmMk35i6zux07JdftFxcFA79 GXwGZnezKn7NrHfvJ9b0ns2c4aCGlnh+hpE1rYl1ut9YKPLudNBaVYdhyTOZFZyd ZaiCljdqRSybZ0QEoHWgdSFzzgQx8nGBmVsbpLz0F1LR0t06c/83qLSrWlBoU6vI 8YEynhRPhwtGpseTZVWELRd/PzkBBlejjKsxb/2jMtQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=SsR/P7 emwZmkSEddHwTr+5rSEK0NGdVTZtmn9vekkXg=; b=RA8kZ58HV5D0Kps0fjie0C DHkLUS7ra7dhrjZIoBDgG2kbzInTHbsih5VymliThStaGGfilkM3TgGcep2pgQKe fOZ3mQ/HnB8a6AslQalQT/C4EHxz2ZOFuh+cccdf6+Sil8N/IGRWGmCTePUmbVoH hOfWS42isZ7U18rpQhuu6GvkjBS4GeAMNNe+3s2iTpYha6ygmznHecaHY96Fk3mh kOibT4OvgER1Iay5I0kCIz3P/mj9F8F4co8uLC7XpwGvmTpI5W/Xur40bQuzPGVD 4HTDKYxggQjAdoQBx1CIxQwJmRHTUSUzRrWdDdk+VSorvyQ8CJCDMl5jVjvBgUKw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrgeehgdduheejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpeffhffvuffkfh ggtggujgesthdtredttddtvdenucfhrhhomheptehnughrvghsucfhrhgvuhhnugcuoegr nhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuffhomhgrihhnpehpohhsthhgrhdrvg hsnecukfhppeelkedrvddutddrudegtddrudejudenucfrrghrrghmpehmrghilhhfrhho mheprghnughrvghssegrnhgrrhgriigvlhdruggvnecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from intern.anarazel.de (c-98-210-140-171.hsd1.ca.comcast.net [98.210.140.171]) by mail.messagingengine.com (Postfix) with ESMTPA id 5A3FA1027C; Wed, 16 Jan 2019 16:56:09 -0500 (EST) Date: Wed, 16 Jan 2019 13:56:07 -0800 From: Andres Freund To: Alvaro Herrera Cc: Stephen Frost , Magnus Hagander , "Jonathan S. Katz" , PostgreSQL WWW Subject: Re: mailing list redirect for bug numbers? Message-ID: <20190116215607.3bfswn4syewmncix@alap3.anarazel.de> References: <20190116195327.GF2528@tamriel.snowman.net> <201901162154.tg6vsmfylacs@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <201901162154.tg6vsmfylacs@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.