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

From: Mike Palmiotto <mike(dot)palmiotto(at)crunchydata(dot)com>
To: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Cc: fte(at)nct(dot)ru, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14682: row level security not work with partitioned table
Date: 2017-06-02 14:24:39
Message-ID: CAMN686FxTNMh1aWyQggjpCwBOewT9c58XcrHYQRPV8fnRYjGHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Thu, Jun 1, 2017 at 10:18 PM, Amit Langote
<Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> On 2017/06/02 3:13, Mike Palmiotto wrote:
>> This is indeed a bug. fireRIRrules is currently skipping the RLS
>> policy check when relkind == PARTITIONED_TABLES, so RLS policies are
>> not applied. The attached patch fixes the behavior.
>
> Thanks Mike for creating the patch. Agree with Michael that a test would
> be nice.

I've got some regression tests in the making. I'll post back here once
I've wrapped those up.

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-06-02 15:09:35 Re: BUG #14683: *** glibc detected *** SELECT: double free or corruption
Previous Message buschmann 2017-06-02 12:19:47 BUG #14684: pg_dump omits columns in inherited tables / psql -d shows deleted columns

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2017-06-02 14:42:42 Re: Range Merge Join v1
Previous Message Claudio Freire 2017-06-02 14:20:47 Re: Perfomance bug in v10