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