Re: Order of execution for permissive RLS policies

2018-07-25 Thread Dean Rasheed
On 24 July 2018 at 15:25, Simon Brent wrote: > I've been using postgres for a while now, and have just started looking in > to row level security. I have found something that I think is a bit strange, > and wanted to know if anyone knows how/why it is the case. > > I have a table with multiple pol

Order of execution for permissive RLS policies

2018-07-24 Thread Simon Brent
I've been using postgres for a while now, and have just started looking in to row level security. I have found something that I think is a bit strange, and wanted to know if anyone knows how/why it is the case. I have a table with multiple policies, each with a USING statement. When I run EXPLA