Re: DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Peter Eisentraut <peter(at)eisentraut(dot)org>, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
Subject: Re: DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows
Date: 2026-08-12 21:30:18
Message-ID: CAAKRu_YZtXSOjQMFm17L0gqP7+BBqk3aKa=tpcW-SnOZWwo_sQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jul 22, 2026 at 2:43 PM Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> wrote:
>
> While testing FOR PORTION OF I noticed that DELETE FOR PORTION OF on a
> view ignores the view's WITH CHECK OPTION for the temporal leftover
> rows it inserts.

[RMT hat]

It's been a few weeks since this was reported, and there hasn't been
engagement by the feature authors. Is this on your radar?
I added an open item [1].

- Melanie

[1] https://wiki.postgresql.org/wiki/PostgreSQL_19_Open_Items

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Paul A Jungwirth 2026-08-12 23:18:59 Re: DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows
Previous Message Zsolt Parragi 2026-08-12 20:56:56 Re: MERGE/SPLIT PARTITIONS issues/questions