Re: How to get SE-PostgreSQL acceptable

Gregory Stark <stark@enterprisedb.com> writes:
> I don't think partitioning is really the same thing as row-level
> security.

Of course not, but it seems to me that it can be used to accomplish most
of the same practical use-cases.  The main gripe about doing it via
partitioning is that the user's nose gets rubbed in the fact that there
can't be an enormous number of different security classifications in the
same table (since he has to explicitly make a partition for each one).
But the proposed implementation of row-level security would poop out
pretty darn quick for such a case, too, and frankly I'm not seeing an
application that would demand it.
        regards, tom lane