On Sat, 27 Jan 2024 at 13:19, David Rowley <dgrowleyml@gmail.com> wrote:
> Are the results correct if you SET enable_presorted_aggregate=0;?
For the record, I don't get the same results as you. Perhaps you have
some other roles that I don't have.
I see:
oid | role_type | rolname | rolsuper | administration
-------+-----------+--------------------+----------+----------------
42077 | User | u6_green_leader_su | f |
(1 row)
It might be worth trying to make the repro more self-contained. Can
you swap out the auth table with a mockup of it?
David