pgsql: doc: Update pg_constraint.conexclop docs for WITHOUT OVERLAPS

doc: Update pg_constraint.conexclop docs for WITHOUT OVERLAPS Fixup for commit fc0438b4e80. Author: Paul A. Jungwirth Discussion: https://www.postgresql.org/message-id/[email protected] Branch -- master Details --- https://git.postgresql.org

pgsql: doc: Add PERIOD to ALTER TABLE reference docs

doc: Add PERIOD to ALTER TABLE reference docs Commit 89f908a6d0a documented foreign keys with PERIOD in the CREATE TABLE docs, but not in ALTER TABLE. This commit adds the new syntax to the ALTER TABLE docs. Author: Paul A. Jungwirth Discussion: https://www.postgresql.org/message-id/57ea0668-5

pgsql: doc: Small improvement in CREATE TABLE / PERIOD documentation

doc: Small improvement in CREATE TABLE / PERIOD documentation Use placeholders that are more consistent and match the description better. Fixup for commit 89f908a6d0a. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/94daf80bd1a2fb078e3a12b80e00f6c578008a08 Modifie

pgsql: doc: Add WITHOUT OVERLAPS to ALTER TABLE reference docs

doc: Add WITHOUT OVERLAPS to ALTER TABLE reference docs Commit fc0438b4e80 documented WITHOUT OVERLAPS in the CREATE TABLE docs, but not in ALTER TABLE. This commit adds the new syntax to the ALTER TABLE docs. Author: Paul A. Jungwirth Discussion: https://www.postgresql.org/message-id/57ea0668

pgsql: Fix pg_upgrade's cross-version tests when old < 18

Fix pg_upgrade's cross-version tests when old < 18 Because in the 18 cycle we turned checksums on by default with commit 04bec894a04c, and pg_upgrade fails if the setting doesn't match in old and new clusters, the built-in cross-version pg_upgrade test is failing if the old version is older than 1

pgsql: configure.ac: Remove useless AC_SUBST

configure.ac: Remove useless AC_SUBST No longer used since commit 805e431a386. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f05b5e6346802d58f23d2ba8370091eab7aa5f63 Modified Files -- configure| 2 -- configure.ac | 1 - 2 files changed, 3 deletions

pgsql: Add nbtree amgettuple return item function.

Add nbtree amgettuple return item function. This makes it easier to add precondition assertions. We now assert that the last call to _bt_readpage succeeded, and that the current item index is within the bounds of the currPos items array. Author: Peter Geoghegan Reviewed-By: Masahiro Ikeda Disc

pgsql: xml2: Add tests for functions xpath_nodeset() and xpath_list()

xml2: Add tests for functions xpath_nodeset() and xpath_list() These two functions with their different argument lists have never been tested in this module, so let's add something. Author: Ronan Dunklau Discussion: https://postgr.es/m/[email protected] Branch -- master Details -

pgsql: contrib/lo: Use SQL-standard function bodies

contrib/lo: Use SQL-standard function bodies Author: Ronan Dunklau Discussion: https://postgr.es/m/3316564.aeNJFYEL58@aivenlaptop Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/13e3796c906befb18c45d4361b2ca0c4f55845c1 Modified Files -- contrib/lo/Makef

pgsql: contrib/lo: Add test for function lo_oid()

contrib/lo: Add test for function lo_oid() Author: Ronan Dunklau Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3ef038fc4f763f8f6a77c5b3406ab7d837c51c4d Modified Files -- contrib/lo/expected/