pgsql: aio: Change prefix of PgAioResultStatus values to PGAIO_RS_

2025-03-22 Thread Andres Freund
aio: Change prefix of PgAioResultStatus values to PGAIO_RS_ The previous prefix wasn't consistent with the naming of other AIO related enum values. It seems best to rename it before the users are introduced. Reported-by: Melanie Plageman Discussion: https://postgr.es/m/caakru_yb+jzqpnsguxcb0gbi

pgsql: plpgsql: make WHEN OTHERS distinct from WHEN SQLSTATE '00000'.

2025-03-22 Thread Tom Lane
plpgsql: make WHEN OTHERS distinct from WHEN SQLSTATE '0'. The catchall exception condition OTHERS was represented as sqlerrstate == 0, which was a poor choice because that comes out the same as SQLSTATE '0'. While we don't issue that as an error code ourselves, there isn't anything parti

pgsql: Improve nbtree array primitive scan scheduling.

2025-03-22 Thread Peter Geoghegan
Improve nbtree array primitive scan scheduling. Add a new scheduling heuristic: don't end the ongoing primitive index scan immediately (at the point where _bt_advance_array_keys notices that the next set of matching tuples must be on a later page) if the primscan already managed to step right/left

pgsql: doc: Remove incorrect description about dropping replication slo

2025-03-22 Thread Fujii Masao
doc: Remove incorrect description about dropping replication slots. pg_drop_replication_slot() can drop replication slots created on a different database than the one where it is executed. This behavior has been in place since PostgreSQL 9.4, when pg_drop_replication_slot() was introduced. Howeve