pgsql: Don't strip $libdir from LOAD command

2025-06-04 Thread Peter Eisentraut
Don't strip $libdir from LOAD command Commit 4f7f7b03758 implemented the extension_control_path GUC, and to make it work it was decided that we should strip the $libdir/ on module_pathname from .control files, so that extensions don't need to worry about this change. This strip logic was implemen

pgsql: doc PG 18 relnotes: Add incompatibility note about checksums now

2025-06-04 Thread Peter Eisentraut
doc PG 18 relnotes: Add incompatibility note about checksums now default Reviewed-by: Tomas Vondra Discussion: https://www.postgresql.org/message-id/flat/CAKAnmmKwiMHik5AHmBEdf5vqzbOBbcwEPHo4-PioWeAbzwcTOQ%40mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/comm

pgsql: doc: Update description of pg_constraint.convalidated

2025-06-04 Thread Peter Eisentraut
doc: Update description of pg_constraint.convalidated The previous description listed the constraint types that this column was used for, but that was outdated, since not-valid not-null constraints are now possible. So just remove that qualification, rather than trying to keep it updated. Author

pgsql: doc: Remove notes about "unencrypted" passwords.

2025-06-04 Thread Nathan Bossart
doc: Remove notes about "unencrypted" passwords. The documentation for the pg_authid system catalog and the pg_shadow system view indicates that passwords might be stored in cleartext, but that hasn't been possible for some time. Oversight in commit eb61136dc7. Reviewed-by: Michael Paquier Disc

pgsql: doc: Remove notes about "unencrypted" passwords.

2025-06-04 Thread Nathan Bossart
doc: Remove notes about "unencrypted" passwords. The documentation for the pg_authid system catalog and the pg_shadow system view indicates that passwords might be stored in cleartext, but that hasn't been possible for some time. Oversight in commit eb61136dc7. Reviewed-by: Michael Paquier Disc

pgsql: doc: Remove notes about "unencrypted" passwords.

2025-06-04 Thread Nathan Bossart
doc: Remove notes about "unencrypted" passwords. The documentation for the pg_authid system catalog and the pg_shadow system view indicates that passwords might be stored in cleartext, but that hasn't been possible for some time. Oversight in commit eb61136dc7. Reviewed-by: Michael Paquier Disc

pgsql: doc: Remove notes about "unencrypted" passwords.

2025-06-04 Thread Nathan Bossart
doc: Remove notes about "unencrypted" passwords. The documentation for the pg_authid system catalog and the pg_shadow system view indicates that passwords might be stored in cleartext, but that hasn't been possible for some time. Oversight in commit eb61136dc7. Reviewed-by: Michael Paquier Disc

pgsql: doc: Remove notes about "unencrypted" passwords.

2025-06-04 Thread Nathan Bossart
doc: Remove notes about "unencrypted" passwords. The documentation for the pg_authid system catalog and the pg_shadow system view indicates that passwords might be stored in cleartext, but that hasn't been possible for some time. Oversight in commit eb61136dc7. Reviewed-by: Michael Paquier Disc

pgsql: doc: Remove notes about "unencrypted" passwords.

2025-06-04 Thread Nathan Bossart
doc: Remove notes about "unencrypted" passwords. The documentation for the pg_authid system catalog and the pg_shadow system view indicates that passwords might be stored in cleartext, but that hasn't been possible for some time. Oversight in commit eb61136dc7. Reviewed-by: Michael Paquier Disc

pgsql: Fix copy-pasto with process count calculation in method_io_uring

2025-06-04 Thread Michael Paquier
Fix copy-pasto with process count calculation in method_io_uring.c This commit replaces the formula used for "TotalProcs" with a call to pgaio_uring_procs() in pgaio_uring_shmem_init() for the shared memory initialization, which is exactly the same, removing a duplication. pgaio_uring_procs() is