Re: Switching to NOINHERIT user triggers #XX000 error - Mailing list pgsql-general

From Tom Lane
Subject Re: Switching to NOINHERIT user triggers #XX000 error
Date
Msg-id 3070156.1730828552@sss.pgh.pa.us
Whole thread Raw
In response to Switching to NOINHERIT user triggers #XX000 error  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Switching to NOINHERIT user triggers #XX000 error
List pgsql-general
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



pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Switching to NOINHERIT user triggers #XX000 error
Next
From: Dominique Devienne
Date:
Subject: Re: Switching to NOINHERIT user triggers #XX000 error