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

From: Joe Conway <mail(at)joeconway(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Mike Palmiotto <mike(dot)palmiotto(at)crunchydata(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, fte(at)nct(dot)ru, PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>, Amit Langote <amitlangote09(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: BUG #14682: row level security not work with partitioned table
Date: 2017-06-11 15:52:55
Message-ID: 24148b5f-23c0-f202-ba27-28526fbccd4b@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On 06/09/2017 02:52 PM, Joe Conway wrote:
> On 06/09/2017 06:16 AM, Joe Conway wrote:
>> On 06/08/2017 11:09 PM, Noah Misch wrote:
>>> On Wed, Jun 07, 2017 at 08:45:20AM -0700, Joe Conway wrote:
>>>> On 06/07/2017 06:49 AM, Mike Palmiotto wrote:
>>>> > I ended up narrowing it down to 4 tables (one parent and 3 partitions)
>>>> > in order to demonstrate policy sorting and order of RLS/partition
>>>> > constraint checking. It should be much more straight-forward now, but
>>>> > let me know if there are any further recommended changes.
>>>>
>>>> Thanks, will take a look towards the end of the day.
>>>
>>> This PostgreSQL 10 open item is past due for your status update. Kindly send
>>> a status update within 24 hours, and include a date for your subsequent status
>>> update. Refer to the policy on open item ownership:
>>> https://www.postgresql.org/message-id/20170404140717.GA2675809%40tornado.leadboat.com
>>
>> I started reviewing the latest patch last night and will try to finish
>> up this afternoon (west coast USA time).
>
> I left the actual (2 line) code change untouched, but I tweaked the
> regression test changes a bit. If there are no complaints I will push
> tomorrow (Saturday).

I waited until Sunday, but pushed none-the-less.

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-06-12 00:19:52 Re: BUG #14701: pg_dump fails to dump pg_catalog schema
Previous Message Alvaro Herrera 2017-06-11 03:28:48 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 Joe Conway 2017-06-11 15:55:21 Re: PG10 Partitioned tables and relation_is_updatable()
Previous Message Christian Ullrich 2017-06-11 15:33:01 Buildfarm failures on woodlouse (in ecpg-check)