I would like to grant read access to all tables in my schema
GRANT SELECT ON ALL TABLES IN SCHEMA public TO XXX;
While it works on our alpha environment, it fails with our production database:
[XX000] ERROR: tuple concurrently updated
There are some examples how to solve regular queries, but when it comes to
GRANT commands it is getting more difficult. According to this so question I understood that another connection is granting/revoking permissions at the same time, something I hardly believe.
Is there a way to identify these other connections? Or in general to circumvent concurrent access to pg_class (i guess)?