Re: [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified
| От | Alvaro Herrera |
|---|---|
| Тема | Re: [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified |
| Дата | |
| Msg-id | 202110012133.rysqravhpzbc@alvherre.pgsql обсуждение исходный текст |
| Ответ на | [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified (David Christensen <david.christensen@crunchydata.com>) |
| Ответы |
Re: [PATCH] Error out if SKIP LOCKED and WITH TIES are both specified
|
| Список | pgsql-hackers |
On 2021-Aug-13, David Christensen wrote: > 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. Thank you, pushed with minimal adjustment. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/ "Digital and video cameras have this adjustment and film cameras don't for the same reason dogs and cats lick themselves: because they can." (Ken Rockwell)
В списке pgsql-hackers по дате отправления: