Hi, On 2026-08-21 13:07:42 +1000, Gabriele Bartolini wrote: > I'd like to propose adding a small column to pg_authid (rollastupdated > timestamptz), that records when a role was last created or altered, and get > feedback on the idea before polishing it for a commitfest (a working > prototype is attached). > > Why?
> Tools that manage PostgreSQL roles declaratively all reconcile in the same > way: given a desired set of roles and attributes, make the live cluster > match it, repeatedly and idempotently. My question is why this is needed for pg_authid and not any of the other catalogs? Adding one-off code for different catalogs one-by-one would ... not be likely to result in good code. Greetings, Andres Freund
