Re: Archives reverse attachment order?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Archives reverse attachment order?
Дата
Msg-id 32719.1445001452@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Archives reverse attachment order?  (Magnus Hagander <magnus@hagander.net>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Archives reverse attachment order?
Следующее
От: Josh Berkus
Дата:
Сообщение: Out-of-policy CitusDB post on Planet