Restore functionality of ALTER {ROLE|DATABASE} SET role (Tom Lane, Noah Misch) §

The fix for CVE-2024-10978 accidentally caused settings for role to not be applied if they come from non-interactive sources, including previous ALTER {ROLE|DATABASE} commands and the PGOPTIONS environment variable.

Fix cases where a logical replication slot's restart_lsn could go backwards (Masahiko Sawada) §

Previously, restarting logical replication could sometimes cause the slot's restart point to be recomputed as an older value than had previously been advertised in pg_replication_slots. This is bad, since for example WAL files might have been removed on the basis of the later restart_lsn value, in which case replication would fail to restart.

Count index scans in contrib/bloom indexes in the statistics views, such as the pg_stat_user_indexes.idx_scan counter (Masahiro Ikeda) §

Fix crash when checking to see if an index's opclass options have changed (Alexander Korotkov) §

Some forms of ALTER TABLE would fail if the table has an index with non-default operator class options.