From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dominique Devienne <ddevienne@gmail.com>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Switching to NOINHERIT user triggers #XX000 error
In-reply-to: <CAFCRh-9byA_kmskbL5duYsjqZG3N78KuvY6TkiT3KuRo27=4QQ@mail.gmail.com>
References: <CAFCRh-9byA_kmskbL5duYsjqZG3N78KuvY6TkiT3KuRo27=4QQ@mail.gmail.com>
Comments: In-reply-to Dominique Devienne <ddevienne@gmail.com>
	message dated "Tue, 05 Nov 2024 18:10:46 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3070155.1730828552.1@sss.pgh.pa.us>
Date: Tue, 05 Nov 2024 12:42:32 -0500
Message-ID: <3070156.1730828552@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3070156.1730828552%40sss.pgh.pa.us>
Precedence: bulk

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