Re: Switching to NOINHERIT user triggers #XX000 error

Dominique Devienne <ddevienne@gmail.com> writes:
> On v16 and v17 though, it works with INHERIT, but with NOINHERIT, I get:
> GRANT "...:USER" TO "ddevienne" #XX000: ERROR:  no possible grantors
> Any clue to what this means, so I can start looking in the right place?

\errverbose in psql would help you locate what part of the code
is throwing that.  (Or if triggering it from psql is not convenient,
set log_error_verbosity = verbose and find the info in the postmaster
log.)

This is probably a bug, at least to the extent that we don't like
XX000 errors to be easily reachable, so please let us know what
you find out.

            regards, tom lane