Re: Archives reverse attachment order?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL WWW <pgsql-www(at)postgresql(dot)org>
Subject: Re: Archives reverse attachment order?
Date: 2015-10-16 08:32:28
Message-ID: CABUevExSmLe7S9FM33DETpCurERpcvQmHF7j8xyWZwuw0nnFqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

On Thu, Oct 15, 2015 at 6:18 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> I posted a message with a batch of patches attached:
> http://www.postgresql.org/message-id/19394.1444865029@sss.pgh.pa.us
> and a note that the patches had to be applied in the order presented.
>
> I'm disappointed to see that the web archives are showing the attachments
> in exactly the opposite order. That could confuse someone no end ...
>

In fact, it was completely unordered - the query that listed the
attachments had no ORDER BY at all. Not entirely sure why but that seems to
have more or less always returned them in the reverse order.

I've added an ORDER BY on the serial column that the attachments get their
id from, which should make it always sort them in the same order as they
were inserted. As usual, it'll take a few hours for the effects to show
through the caching.

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

In response to

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Tom Lane 2015-10-16 13:17:32 Re: Archives reverse attachment order?
Previous Message Tom Lane 2015-10-15 04:18:25 Archives reverse attachment order?