Hi, I have a weird case when running a query on the pg_settings view. I have two users, first one is the default user - postgres which is a superuser and another one is a role which i had created, i called it test_role and it's not a superuser. When I run a select on pg_settings with these two users I recieve different results. Running the query 'select * from pg_settings' with 'postgres' user returns 269 rows when running the same query with 'test_role' returns 254 rows. For example, the following query 'select lower(setting) from pg_settings where lower(name) = 'config_file'' returns null when I connect with 'test_role' but with 'postgres' user I recieve one row (/var/lib/pgsql/9.6/data/postgresql.conf).
I have granted all privileges on pg_settings to 'test_role' but it didn't changed the results. I don't have any idea what it's wrong here. The PostgreSQL version is PostgreSQL 9.6.1 on x86_64-pc-linux-gnu Can you please help me with this issue? Thanks in advance, Ronen
