Re: [PATCH] Use role name "system_user" instead of "user" for unsafe_tests - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] Use role name "system_user" instead of "user" for unsafe_tests
Date
Msg-id 508365.1681243417@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Use role name "system_user" instead of "user" for unsafe_tests  (Aleksander Alekseev <aleksander@timescale.com>)
Responses Re: [PATCH] Use role name "system_user" instead of "user" for unsafe_tests
List pgsql-hackers
Aleksander Alekseev <aleksander@timescale.com> writes:
>> I don't think we can protect against all possible user names. Wouldn't it be better to run the tests under an OS
userwith a different name, like "marmaduke"? ("user" is a truly terrible default user name). 

> 100% agree. The point is not to protect against all possible user
> names but merely to reduce the likelihood of the problem.

It only reduces the likelihood if you assume that "system_user"
is less likely than "user" as a choice of OS user name to run
the tests under.  That seems like a debatable assumption;
perhaps it's actually *more* likely.

Whether we need to have a test for this at all is perhaps a
more interesting argument.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: v12: ERROR: subplan "InitPlan 2 (returns $4)" was not initialized
Next
From: Andres Freund
Date:
Subject: Re: Minimal logical decoding on standbys