Re: Archives reverse attachment order? - Mailing list pgsql-www

From Tom Lane
Subject Re: Archives reverse attachment order?
Date
Msg-id 32719.1445001452@sss.pgh.pa.us
Whole thread Raw
In response to Re: Archives reverse attachment order?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-www
Magnus Hagander <magnus@hagander.net> writes:
> On Thu, Oct 15, 2015 at 6:18 AM, Tom Lane <tgl@sss.pgh.pa.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



pgsql-www by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Archives reverse attachment order?
Next
From: Josh Berkus
Date:
Subject: Out-of-policy CitusDB post on Planet