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