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

From: Noah Misch <noah(at)leadboat(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Mike Palmiotto <mike(dot)palmiotto(at)crunchydata(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
Subject: Re: BUG #14682: row level security not work with partitioned table
Date: 2017-06-04 22:33:14
Message-ID: 20170604223314.GB1547727@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Fri, Jun 02, 2017 at 09:28:16AM +0900, Michael Paquier wrote:
> On Thu, Jun 1, 2017 at 11:13 AM, Mike Palmiotto
> <mike(dot)palmiotto(at)crunchydata(dot)com> 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.
>
> I would expect RLS to trigger as well in this context. Note that there
> should be regression tests to avoid this failure again in the future.
> I have added an open item.

[Action required within three days. This is a generic notification.]

The above-described topic is currently a PostgreSQL 10 open item. Robert,
since you committed the patch believed to have created it, you own this open
item. If some other commit is more relevant or if this does not belong as a
v10 open item, please let us know. Otherwise, please observe the policy on
open item ownership[1] and send a status update within three calendar days of
this message. Include a date for your subsequent status update. Testers may
discover new open items at any time, and I want to plan to get them all fixed
well in advance of shipping v10. Consequently, I will appreciate your efforts
toward speedy resolution. Thanks.

[1] https://www.postgresql.org/message-id/20170404140717.GA2675809%40tornado.leadboat.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2017-06-04 23:10:12 Re: BUG #14687: pg_xlogdump does only count "main data" for record length and leading to incorrect statistics
Previous Message Noah Misch 2017-06-04 22:24:30 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 Noah Misch 2017-06-04 22:45:47 Re: Error while creating subscription when server is running in single user mode
Previous Message Tom Lane 2017-06-04 22:30:13 Re: retry shm attach for windows (WAS: Re: OK, so culicidae is *still* broken)