Re: RLS creates inaccurate limit and offset results

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: RLS creates inaccurate limit and offset results
Дата
Msg-id E02822A7-6755-476C-AE78-5DDBE69304C4@thebuild.com
обсуждение исходный текст
Ответ на RLS creates inaccurate limit and offset results  (mike@mikebrancato.com)
Ответы Re: RLS creates inaccurate limit and offset results
Список pgsql-bugs

> On Nov 11, 2025, at 08:29, mike@mikebrancato.com wrote:
> I have noticed that using row level security can cause use of `LIMIT` and `OFFSET` to return inconsistent results
withoutthe use of an explicit `ORDER BY`. 

LIMIT and OFFSET without ORDER BY are not guaranteed to return consistent results even without RLS.  RLS may cause it
bemore obvious, however. 


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