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
