Hi all! We are evaluating migrating our software RLS to Postgres by using policies.
Having a "FOR UPDATE POLICY" on a table, I was wondering if there is a way to know, before trying an Update and getting an error, if the current row can be updated ? The goal is to show or hide the edit button in my software forms or lists. I know that this query can return the CHECK condition of my POLICY: SELECT pg_get_expr(polwithcheck, polrelid, true) FROM pg_policy; But is there a simpler way to get the ids the current user can read and the ones that he can update? Thank you! Jeff
