Re: Document ordering guarantees on INSERT/UPDATE RETURNING clause

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Document ordering guarantees on INSERT/UPDATE RETURNING clause
Дата
Msg-id CAKFQuwZYmqiRq5nTh8ghcfSZ0Qsx6AHbzNArMLLEX0xfeSwLOg@mail.gmail.com
обсуждение исходный текст
Ответ на Document ordering guarantees on INSERT/UPDATE RETURNING clause  (Shay Rojansky <roji@roji.org>)
Ответы Re: Document ordering guarantees on INSERT/UPDATE RETURNING clause  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers
On Sat, Feb 26, 2022 at 5:42 AM Shay Rojansky <roji@roji.org> wrote:
FWIW I've received feedback from a SQL Server engineer that one definitely should *not* depend on such ordering there, and that future optimizations (e.g. parallel insertion of many rows) could result in row ordering which differs from the lexical ordering of the VALUES clause.
 
That seems very reasonable; if the situation is similar on PostgreSQL, then I'd suggest making that very clear in the INSERT[2] and UPDATE[3] docs.

There is clearly no mention of such a guarantee in our documentation.

David J.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Shay Rojansky
Дата:
Сообщение: Document ordering guarantees on INSERT/UPDATE RETURNING clause
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Document ordering guarantees on INSERT/UPDATE RETURNING clause