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