Re: Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows

From: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
Subject: Re: Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows
Date: 2026-06-30 07:51:40
Message-ID: CAJTYsWWJeKKY=Db3R2yP7X8CeHoEu1tFcrRHKRgAf4Fv5-P11g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Tue, 30 Jun 2026 at 13:16, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:

> Hi,
>
> While revisiting “[8e72d914c] Add UPDATE/DELETE FOR PORTION OF”, I found a
> new issue where inserting leftover rows may skip row-level security checks.
>

Please see if it is the same as this: PostgreSQL: Enforce INSERT RLS
checks for FOR PORTION OF leftovers?
<https://www.postgresql.org/message-id/flat/CAJTYsWWdeBkoH5g8D-k9LDw9ciqsMxb21EJSiFXAzP4J=XyxOQ(at)mail(dot)gmail(dot)com>

If yes, it is already present in the PG 19 open list.

Regards,
Ayush

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-06-30 07:59:04 Re: Add pg_stat_kind_info system view
Previous Message Ashutosh Sharma 2026-06-30 07:46:53 Re: Support EXCEPT for ALL SEQUENCES publications