Re: [GENERAL] Querying a policy

2017-05-11 Thread Jean-Francois Bernier
Stephen, Thank you for the quick reply! This information is very useful to me. Maybe some more questions will come in the future :) Thanks again and continue the good work! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.

Re: [GENERAL] Querying a policy

2017-05-10 Thread Stephen Frost
Jeff, * Jean-Francois Bernier (jean.francois.bern...@boreal-is.com) wrote: > We are evaluating migrating our software RLS to Postgres by using policies. Neat! > 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

[GENERAL] Querying a policy

2017-05-10 Thread Jean-Francois Bernier
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