Re: Switching to NOINHERIT user triggers #XX000 error

2024-11-05 Thread Dominique Devienne
On Tue, Nov 5, 2024 at 7:25 PM Tom Lane wrote: > Dominique Devienne writes: > > On Tue, Nov 5, 2024 at 6:42 PM Tom Lane wrote: > >> 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. > > > Find

Re: Switching to NOINHERIT user triggers #XX000 error

2024-11-05 Thread Tom Lane
Dominique Devienne writes: > On Tue, Nov 5, 2024 at 6:42 PM Tom Lane wrote: >> 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. > Finding where the error is thrown is easy, it's when I'm doing th

Re: Switching to NOINHERIT user triggers #XX000 error

2024-11-05 Thread Dominique Devienne
On Tue, Nov 5, 2024 at 6:42 PM Tom Lane wrote: > Dominique Devienne 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 pl

Re: Switching to NOINHERIT user triggers #XX000 error

2024-11-05 Thread Tom Lane
Dominique Devienne 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 par

Switching to NOINHERIT user triggers #XX000 error

2024-11-05 Thread Dominique Devienne
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 "dde