Re: [BUGS] BUG #14682: row level security not work with partitioned table

From: Mike Palmiotto <mike(dot)palmiotto(at)crunchydata(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Joe Conway <mail(at)joeconway(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, fte(at)nct(dot)ru, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #14682: row level security not work with partitioned table
Date: 2017-06-06 18:57:22
Message-ID: CAMN686FAQ8ywtJF+UsdcM+03VV4-MM60bXNh3Lz-q=TEoPiN_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Mon, Jun 5, 2017 at 10:36 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Mon, Jun 5, 2017 at 10:20 AM, Joe Conway <mail(at)joeconway(dot)com> wrote:
>> Unless Robert objects, I'll work with Mike to get a fix posted and
>> committed in the next day or two.
>
> That would be great. Thanks.

I have the updated patch with rowsecurity regression tests and rebased
on master. I've run these and verified locally by feeding
rowsecurity.sql to psql, but have yet to get the full regression suite
passing -- it's failing on the constraints regtest and then gets stuck
in recovery. Undoubtedly something to do with my
configuration/environment over here. I'm working through those issues
right now. In the meantime, if you want to see the regression tests as
they stand, please see the attached patch.

Thanks,

--
Mike Palmiotto
Software Engineer
Crunchy Data Solutions
https://crunchydata.com

Attachment Content-Type Size
0001-Add-RLS-support-to-partitioned-tables.patch text/x-patch 12.0 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Conway 2017-06-06 20:07:13 Re: BUG #14682: row level security not work with partitioned table
Previous Message Michael Paquier 2017-06-06 04:17:35 Re: Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog

Browse pgsql-hackers by date

  From Date Subject
Next Message Erik Rijkers 2017-06-06 19:01:25 Re: logical replication - still unstable after all these months
Previous Message Peter Eisentraut 2017-06-06 18:53:48 Re: logical replication - still unstable after all these months