Re: Allow placeholders in ALTER ROLE w/o superuser - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allow placeholders in ALTER ROLE w/o superuser
Date
Msg-id 2271312.1668807199@sss.pgh.pa.us
Whole thread Raw
In response to Re: Allow placeholders in ALTER ROLE w/o superuser  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: Allow placeholders in ALTER ROLE w/o superuser
Re: Allow placeholders in ALTER ROLE w/o superuser
List pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes:
> This makes sense.  But do we really need to store the OID of the role?
>  validate_option_array_item() already checks if the placeholder option
> passes validation for PGC_SUSET.  So, we can just save a flag
> indicating that this check was not successful.  If so, then the value
> stored can be only used for PGC_USERSET.  Do you think this would be
> correct?

Meh ... doesn't seem like much of an improvement.  You still need
to store something that's not there now.  This also seems to require
some shaky assumptions about decisions having been made when storing
still being valid later on.  Given the possibility of granting or
revoking permissions for SET, I think we don't really want it to act
that way.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Allow placeholders in ALTER ROLE w/o superuser
Next
From: Justin Pryzby
Date:
Subject: Re: fix stats_fetch_consistency value in postgresql.conf.sample