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

From Dominique Devienne
Subject Switching to NOINHERIT user triggers #XX000 error
Date
Msg-id CAFCRh-9byA_kmskbL5duYsjqZG3N78KuvY6TkiT3KuRo27=4QQ@mail.gmail.com
Whole thread Raw
Responses Re: Switching to NOINHERIT user triggers #XX000 error
List pgsql-general
Hi. Still working on porting our stuff to v16+, with the ROLE changes.

I'm facing a new issue. The same code and unit test works in v14,
when the LOGIN user running the test is INHERIT or NOINHERIT.

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?

In all 3 (or 6) cases, the code is the same, the client-side is
running libpq 17,
it's only the server that changes. The LOGIN user is the same, with the same
pg_roles attributes, with again the variable being INHERIT or not. --DD



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres listens on random port
Next
From: Tom Lane
Date:
Subject: Re: Switching to NOINHERIT user triggers #XX000 error