Обсуждение: Archives reverse attachment order?
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 ... regards, tom lane
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.
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