Re: [HACKERS] Multi-tenancy with RLS - Mailing list pgsql-hackers

From Haribabu Kommi
Subject Re: [HACKERS] Multi-tenancy with RLS
Date
Msg-id CAJrrPGf4Vv_OVu2UgJw2Oc1h5Sk1nXgQOCQRUYJKP_5+QZ_Erw@mail.gmail.com
Whole thread Raw
In response to Re: Multi-tenancy with RLS  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-hackers


On Mon, Dec 5, 2016 at 4:31 PM, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:


On Mon, Oct 3, 2016 at 3:11 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Tue, Jul 19, 2016 at 3:42 PM, Haribabu Kommi
<kommi.haribabu@gmail.com> wrote:
> The above changes are based on my understanding to the discussion occurred in
> this mail. In case if I miss anything, please let me know, i will
> correct the same.

The patch series still apply.

+                   " ((classid = (select oid from pg_class where
relname = 'pg_aggregate'))"
+                   " OR (classid = (select oid from pg_class where
relname = 'pg_cast') AND has_cast_privilege(objid, 'any'))"
+                   " OR (classid = (select oid from pg_class where
relname = 'pg_collation'))"
[... long list ...]
That's quite hard to digest...

+static bool
+get_catalog_policy_string(Oid relationid, Form_pg_class
pg_class_tuple, char *buf)
This is an exceptionally weak interface at quick glance. This is using
SQL strings, and nothing is actually done regarding potentially
conflicting name types...

The number of new files included in policy.c is impressive as well..

This does not count as a full review though, so I am moving it to next
CF. Perhaps it will find its audience.

As the patch doesn't receive full review. Just kept in the commitfest to
see any interest from others for this patch.

Moved to next CF with "needs review" status.

This patch is not generating much interest from the community, may be
because of the design that is chosen to implement multi-tenancy.

Currently this patch is marked as rejected. 

Regards,
Hari Babu
Fujitsu Australia

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Commit fest 2017-01 will begin soon!
Next
From: Vladimir Borodin
Date:
Subject: Re: [HACKERS] Review: GIN non-intrusive vacuum of posting tree