On Saturday, September 16, 2023, Koen De Groote <kdg.dev@xxxxxxxxx> wrote:
ERROR: role "X" cannot be dropped because some objects depend on it
DETAIL: privileges for default privileges on new functions belonging to role postgres in schema publicThe "new functions" bit is confusing. I've swapped over all the current functions, but cannot seem to find the appropriate table for privileges on new functions.What am I missing here?
Alter default privileges.