[PATCH] Error out if SKIP LOCKED and WITH TIES are both specified

Поиск
Список
Период
Сортировка
От David Christensen
Тема [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified
Дата
Msg-id CAOxo6XLPccCKru3xPMaYDpa+AXyPeWFs+SskrrL+HKwDjJnLhg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Both bugs #16676[1] and #17141[2] illustrate that the combination of SKIP LOCKED and FETCH FIRST
WITH TIES break expectations when it comes to rows returned to other sessions accessing the same
row.  Since this situation is detectable from the syntax and hard to fix otherwise, forbid for now,
with the potential to fix in the future.

[1] https://www.postgresql.org/message-id/16676-fd62c3c835880da6%40postgresql.org
[2] https://www.postgresql.org/message-id/17141-913d78b9675aac8e%40postgresql.org

Proposed backpatch to 13.
Вложения

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

Предыдущее
От: Ranier Vilela
Дата:
Сообщение: Re: Multiple Postgres process are running in background
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Default to TIMESTAMP WITH TIME ZONE?