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

2017-06-07 Thread Mike Palmiotto
On Wed, Jun 7, 2017 at 9:49 AM, Mike Palmiotto wrote: > One thing that concerns me is the first EXPLAIN plan from regress_rls_dave: > +EXPLAIN (COSTS OFF) SELECT * FROM part_document WHERE f_leak(dtitle); > + QUERY PLAN > +---

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

2017-06-07 Thread Mike Palmiotto
On Tue, Jun 6, 2017 at 9:12 PM, Michael Paquier wrote: > On Wed, Jun 7, 2017 at 9:52 AM, Joe Conway wrote: >> Thanks Mike. I'll take a close look to verify output correctnes, but I >> am concerned that the new tests are unnecessarily complex. Any other >> opinions on that? > > Some tests would be

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

2017-06-06 Thread Michael Paquier
On Wed, Jun 7, 2017 at 9:52 AM, Joe Conway wrote: > On 06/06/2017 02:44 PM, Mike Palmiotto wrote: >> On Tue, Jun 6, 2017 at 4:07 PM, Joe Conway wrote: >>> On 06/06/2017 11:57 AM, Mike Palmiotto wrote: On Mon, Jun 5, 2017 at 10:36 AM, Robert Haas wrote: > On Mon, Jun 5, 2017 at 10:20 AM,

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

2017-06-06 Thread Mike Palmiotto
On Tue, Jun 6, 2017 at 4:07 PM, Joe Conway wrote: > On 06/06/2017 11:57 AM, Mike Palmiotto wrote: >> On Mon, Jun 5, 2017 at 10:36 AM, Robert Haas wrote: >>> On Mon, Jun 5, 2017 at 10:20 AM, Joe Conway wrote: Unless Robert objects, I'll work with Mike to get a fix posted and committed i

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

2017-06-06 Thread Mike Palmiotto
On Mon, Jun 5, 2017 at 10:36 AM, Robert Haas wrote: > On Mon, Jun 5, 2017 at 10:20 AM, Joe Conway 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 regressi

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

2017-06-05 Thread Robert Haas
On Mon, Jun 5, 2017 at 10:20 AM, Joe Conway 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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgs