Hello
I am playing with RLS. I created simple table
table_data (inserted_by text, v integer);
I created two policies
create policy p1 on data with check (inserted_by = session_user);
create policy p2 on data with check (v between 10 and 1000);
I was surprised so p2 effectively disables p1;
next a message:
ERROR: new row violates WITH CHECK OPTION for "data"
DETAIL: Failing row contains (2014-10-05 12:28:30.79652, petr, 1000).
Doesn't inform about broken policy.
Regards
Pavel