pgsql: Reorder superuser check in pg_log_backend_memory_contexts() - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Reorder superuser check in pg_log_backend_memory_contexts()
Date
Msg-id E1lqPFM-0005V3-Sa@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Reorder superuser check in pg_log_backend_memory_contexts()

The use of this function is limited to superusers and the code includes
a hardcoded check for that.  However, the code would look for the PGPROC
entry to signal for the memory dump before checking if the user is a
superuser or not, which does not make sense if we know that an error
will be returned.  Note that the code would let one know if a process
was a PostgreSQL process or not even for non-authorized users, which is
not the case now, but this avoids taking ProcArrayLock that will most
likely finish by being unnecessary.

Thanks to Julien Rouhaud and Tom Lane for the discussion.

Discussion: https://postgr.es/m/YLxw1uVGIAP5uMPl@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4e47b02834827fa700627290fae02f89a450368c

Modified Files
--------------
src/backend/utils/adt/mcxtfuncs.c | 16 +++++++++-------
1 file changed, 9 insertions(+), 7 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Add _outTidRangePath()
Next
From: Michael Paquier
Date:
Subject: pgsql: Remove unnecessary declaration in win32_port.h