Re: Assert failure with MERGE into partitioned table with RLS - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Assert failure with MERGE into partitioned table with RLS
Date
Msg-id CAEZATCXwJdOpnkb-NAmKkU0JRA5edkJNeJJHAsWqFQzC1tXPbA@mail.gmail.com
Whole thread Raw
In response to Assert failure with MERGE into partitioned table with RLS  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
On Mon, 20 Feb 2023 at 16:18, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> As part of the MERGE RETURNING patch I noticed a suspicious Assert()
> in ExecInitPartitionInfo() that looked like it needed updating for
> MERGE.
>
> After more testing, I can confirm that this is indeed a pre-existing
> bug, that can be triggered using MERGE into a partitioned table that
> has RLS enabled (and hence non-empty withCheckOptionLists to
> initialise).
>
> So I think we need something like the attached.
>

Pushed and back-patched.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Disable rdns for Kerberos tests
Next
From: Alvaro Herrera
Date:
Subject: Re: LWLock deadlock in brinRevmapDesummarizeRange