Re: Multi-tenancy with RLS

* Robert Haas (robertmhaas@gmail.com) wrote:
> On Tue, Sep 15, 2015 at 9:18 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> > Also, we've faced issues in the past with making catalog changes due to fear
> > of breaking user scripts. Instead of doubling down on that with RLS on top
> > of catalog tables, would it be better to move the tables to a different
> > schema, make them accessible only to superusers and put views in pg_catalog?
>
> Uggh.  -1 on that option from me.

Yeah, -1 from here too...  That way leads to madness (note that we still
haven't managed to get rid of the pg_user, et al,
backwards-compatibility views from, uh, 8.2?).

Thanks!

Stephen