Request a Demo
Home   >   mailing lists

Re: RLS creates inaccurate limit and offset results - Mailing list pgsql-bugs

From Christophe Pettus
Subject Re: RLS creates inaccurate limit and offset results
Date
Msg-id E02822A7-6755-476C-AE78-5DDBE69304C4@thebuild.com
Whole thread Raw
In response to RLS creates inaccurate limit and offset results  (mike@mikebrancato.com)
Responses Re: RLS creates inaccurate limit and offset results
List pgsql-bugs
Tree view 

> 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18
Next
From: mike@mikebrancato.com
Date:
Subject: Re: RLS creates inaccurate limit and offset results