Re: Commit fest?

Greg Smith wrote:
> On Sun, 16 Mar 2008, Bruce Momjian wrote:
>
>> Oh, what I would really like is to be able to pull up
>> archives.postgresql.org emails based on message id so I can link to
>> the entire thread. Unfortunately, it doesn't work there, nor does
>> Google or any of the other Postgres email archive sites.
>
> This is something I've been looking into my own organization. The
> message ids are at the start of the archive web pages. For example your
> e-mail here I'm replying to begins like this if you look at the page
> source:
>
> http://archives.postgresql.org/pgsql-hackers/2008-03/msg00554.php
> <!-- MHonArc v2.6.16 -->
> <!--X-Subject: Re: Commit fest? -->
> <!--X-From-R13: Pehpr [bzwvna <oehprNzbzwvna.hf> -->
> <!--X-Date: Sun, 16 Mar 2008 23:19:33 &#45;0300 (ADT) -->
> <!--X-Message-Id: 200803170219(dot)m2H2JRQ11863(at)momjian(dot)us -->
> <!--X-Content-Type: text/plain -->
> <!--X-Reference: 20681(dot)1205719990(at)sss(dot)pgh(dot)pa(dot)us -->
> <!--X-Head-End-->
>
> I was thinking of writing something that scraped the archives building a
> lookup table out of this information. What would be nice is if the
> X-Message-Id and X-Reference were both put into the regular HTML for
> future archived messages so that it's more likely tools like Google
> could search based on them. A brief glance at the MHonArc documentation
> suggests that could be run to re-covert any existing messages that are
> still available in order to add to those even.

We are sucking a lot of this data down to the db on
search.postgresql.org already. Does it make sense to do it there
perhaps? Is there need for anything more than a unique-messageid-hit? If
that's all we need, we could easily have an url like
http://search.postgresql.org/search?msgid=19873987123(at)foo(dot)com redirect
to the proper page on archives?

//Magnus