Re: Archives reverse attachment order?

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

Magnus Hagander <magnus(at)hagander(dot)net> writes:
> 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.

Looks better now. Thanks!

regards, tom lane

In response to

Browse pgsql-www by date

  From Date Subject
Next Message Josh Berkus 2015-10-19 17:07:55 Out-of-policy CitusDB post on Planet
Previous Message Magnus Hagander 2015-10-16 08:32:28 Re: Archives reverse attachment order?