Life with Open Source

PostgreSQL 15.0 (upcoming) commit log

doc: Properly punctuate "etc." commit : 648aa6734fefb2cc2c9bba7d6444890e727eaca1 author : Peter Eisentraut <peter@eisentraut.org> date : Thu, 19 May 2022 09:27:34 +0200 committer: Peter Eisentraut <peter@eisentraut.org> date : Thu, 19 May 2022 09:27:34 +0200 Click here for diff M doc/src/sgml/arch-dev.sgml M doc/src/sgml/bki.sgml M doc/src/sgml/config.sgml M doc/src/sgml/datetime.sgml M doc/src/sgml/ddl.sgml M doc/src/sgml/extend.sgml M doc/src/sgml/func.sgml M doc/src/sgml/glossary.sgml M doc/src/sgml/libpq.sgml M doc/src/sgml/manage-ag.sgml M doc/src/sgml/plperl.sgml M doc/src/sgml/pltcl.sgml M doc/src/sgml/postgres-fdw.sgml M doc/src/sgml/protocol.sgml M doc/src/sgml/ref/values.sgml

PostgreSQL 14.0 (upcoming) commit log

Fix incorrect comments for Memoize struct commit : 3f712ea6dc40a0c9d5cf96907655343039601473 author : David Rowley <drowley@postgresql.org> date : Thu, 19 May 2022 17:14:56 +1200 committer: David Rowley <drowley@postgresql.org> date : Thu, 19 May 2022 17:14:56 +1200 Click here for diff Reported-by: Peter Eisentraut Discussion: https://postgr.es/m/0635f5aa-4973-8dc2-4e4e-df9fd5778a65@enterprisedb.com Backpatch-through: 14, where Memoize was added M src/include/nodes/plannodes.h Update xml_1.out and xml_2.out commit : e8b93c6e2810306887dc8477aab88ae08cf335f9 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 committer: Alvaro Herrera <alvherre@alvh.

PostgreSQL 10.22 (upcoming) commit log

Update xml_1.out and xml_2.out commit : 29d11151875fb7b4c76ac7b03444dcd7b4a8597f author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 committer: Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 Click here for diff Commit 0fbf01120023 should have updated them but didn't. M src/test/regress/expected/xml_1.out M src/test/regress/expected/xml_2.out Check column list length in XMLTABLE/JSON_TABLE alias commit : 16cb7db34f3c0a3b6e2973f6efbc6f2afa58c66a author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 20:28:31 +0200 committer: Alvaro Herrera <alvherre@alvh.

PostgreSQL 11.17 (upcoming) commit log

Update xml_1.out and xml_2.out commit : 50bf3157a1a5cd7196ba5b5feaca4b71e035afb4 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 committer: Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 Click here for diff Commit 0fbf01120023 should have updated them but didn't. M src/test/regress/expected/xml_1.out M src/test/regress/expected/xml_2.out Check column list length in XMLTABLE/JSON_TABLE alias commit : ba83de8ada5b4a179b93874f39241ed5e00226b2 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 20:28:31 +0200 committer: Alvaro Herrera <alvherre@alvh.

PostgreSQL 12.12 (upcoming) commit log

Update xml_1.out and xml_2.out commit : 0ebd20e20ff48a5df16ebfa49947c4044b948fa8 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 committer: Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 Click here for diff Commit 0fbf01120023 should have updated them but didn't. M src/test/regress/expected/xml_1.out M src/test/regress/expected/xml_2.out Check column list length in XMLTABLE/JSON_TABLE alias commit : ade17703def9c8820d1a47cd21f37b1eb5656f89 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 20:28:31 +0200 committer: Alvaro Herrera <alvherre@alvh.

PostgreSQL 13.0 (upcoming) commit log

Update xml_1.out and xml_2.out commit : 5139db55636bc39c06232ada1b195f7d5d6950e0 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 committer: Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 23:19:53 +0200 Click here for diff Commit 0fbf01120023 should have updated them but didn't. M src/test/regress/expected/xml_1.out M src/test/regress/expected/xml_2.out Check column list length in XMLTABLE/JSON_TABLE alias commit : 80656f00f85668bb828c1eb878876e5bedcbf4c4 author : Alvaro Herrera <alvherre@alvh.no-ip.org> date : Wed, 18 May 2022 20:28:31 +0200 committer: Alvaro Herrera <alvherre@alvh.

pgBackRest 2.41 (upcoming) commit log

Improve memory usage of mem contexts. commit : c7a66ac1afb9a55b049dc18493b602b7bf62bda4 author : David Steele <david@pgmasters.net> date : Wed, 18 May 2022 10:52:01 -0400 committer: GitHub <noreply@github.com> date : Wed, 18 May 2022 10:52:01 -0400 Click here for diff Each mem context can track child contexts, allocations, and a callback. Before this change memory was allocated for tracking all three even if they were not used for a particular context.

pgBackRest 2.40 commit log

v2.39: Verify and File Bundling commit : 901e829f6dd05fdc15d899bc7f1108883002b1d5 author : David Steele <david@pgmasters.net> date : Mon, 16 May 2022 08:46:24 -0400 committer: David Steele <david@pgmasters.net> date : Mon, 16 May 2022 08:46:24 -0400 Click here for diff Bug Fixes: * Fix error thrown from FINALLY() causing an infinite loop. (Reviewed by Stephen Frost.) * Error on all lock failures except another process holding the lock. (Reviewed by Reid Thompson, Geir RĂ¥ness.

PostgreSQL 10.21 commit log

Stamp 10.21. commit : 6979736b4bcdc57e4699eadcca44b699fd1afd29 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:21:58 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:21:58 -0400 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : db034c2e2e45216439c14e2b7bb99260914d610f author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 11.16 commit log

Stamp 11.16. commit : 6ac9161f69829fe327e393bff83d5f390105a70f author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:20:11 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:20:11 -0400 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : b5576e1b701c8d690ed1ea8d3c17d5df49de3d7c author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 committer: Tom Lane <tgl@sss.

PostgreSQL 12.11 commit log

Stamp 12.11. commit : f4206b3e5f816bcc45511411bb208d21a68a7e6a author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:18:31 -0400 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 17:18:31 -0400 Click here for diff M configure M configure.in M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Last-minute updates for release notes. commit : b4516b1aea7ac98bc21b47a66ad384f50c2bd2b7 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 9 May 2022 14:29:53 -0400 committer: Tom Lane <tgl@sss.

pgBackRest 2.39 commit log

v2.38: Minor Bug Fixes and Improvements commit : 5249b89a2e94fdbb45461faaf2e1b0304b986ac7 author : David Steele <david@pgmasters.net> date : Sun, 6 Mar 2022 10:30:59 -0600 committer: David Steele <david@pgmasters.net> date : Sun, 6 Mar 2022 10:30:59 -0600 Click here for diff IMPORTANT NOTE: Repository size reported by the info command is now entirely based on what pgBackRest has written to storage. Previously, in certain cases, pgBackRest could detect if additional compression was being applied by the storage but this is no longer supported.

pgAudit 1.2.5 commit log

Stamp 1.2.4. commit : 6d9e5d4ae4b0baf5039845fb71f6e7d52669bbd8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:30:21 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:30:21 -0600 Click here for diff M Makefile A pgaudit–1.2.3–1.2.4.sql R100 pgaudit–1.2.3.sql pgaudit–1.2.4.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 74c4c07899fba3cc7bc791be6b03810786b06762 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 14:16:17 -0600 committer: David Steele <david@pgmasters.

pgAudit 1.3.5 commit log

Stamp 1.3.4. commit : 6f7799839465a39dc1887e4ad10ef2f67519cd1e author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:25:39 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:25:39 -0600 Click here for diff M Makefile A pgaudit–1.3.3–1.3.4.sql R100 pgaudit–1.3.3.sql pgaudit–1.3.4.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 0a41dfcdb5fcd52d9da1ee0c1c2d174e15934fe8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 13:47:40 -0600 committer: David Steele <david@pgmasters.

pgAudit 1.4.4 commit log

Stamp 1.4.3. commit : 21fea0792139529302e02af145c90f7ec5cff2eb author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:19:52 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:19:52 -0600 Click here for diff M Makefile A pgaudit–1.4.2–1.4.3.sql R100 pgaudit–1.4.2.sql pgaudit–1.4.3.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 28ab91b8cee30da902d33b3b61a8b62934814370 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 12:37:07 -0600 committer: David Steele <david@pgmasters.

pgAudit 1.5.3 commit log

Stamp 1.5.2. commit : 59d9574ab966f69a549e3f8f60c1829ee5b78b3b author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:14:43 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:14:43 -0600 Click here for diff M Makefile A pgaudit–1.5.1–1.5.2.sql R100 pgaudit–1.5.1.sql pgaudit–1.5.2.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 30996af6fc5dd4a832e8d57b05179482867d109b author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 12:10:53 -0600 committer: David Steele <david@pgmasters.

pgAudit 1.4.5 (upcoming) commit log

Stamp 1.6.2. commit : 267eb83a14ca29f37821f297974991206aa91dee author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:00:56 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:00:56 -0600 Click here for diff M Makefile A pgaudit–1.6.1–1.6.2.sql R100 pgaudit–1.6.1.sql pgaudit–1.6.2.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 6460d9fec78c344245c70309551bb314415268a8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 11:27:12 -0600 committer: GitHub <noreply@github.

pgAudit 1.5.4 (upcoming) commit log

Stamp 1.6.2. commit : 267eb83a14ca29f37821f297974991206aa91dee author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:00:56 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:00:56 -0600 Click here for diff M Makefile A pgaudit–1.6.1–1.6.2.sql R100 pgaudit–1.6.1.sql pgaudit–1.6.2.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 6460d9fec78c344245c70309551bb314415268a8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 11:27:12 -0600 committer: GitHub <noreply@github.

pgAudit 1.6.3 commit log

Stamp 1.6.2. commit : 267eb83a14ca29f37821f297974991206aa91dee author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:00:56 -0600 committer: David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 15:00:56 -0600 Click here for diff M Makefile A pgaudit–1.6.1–1.6.2.sql R100 pgaudit–1.6.1.sql pgaudit–1.6.2.sql M pgaudit.control Skip logging script statements for create/alter extension. commit : 6460d9fec78c344245c70309551bb314415268a8 author : David Steele <david@pgmasters.net> date : Fri, 25 Feb 2022 11:27:12 -0600 committer: GitHub <noreply@github.

PostgreSQL 9.6.25 (upcoming) commit log

Use gendef instead of pexports for building windows .def files commit : 622ab6a34f968610acfbc21d295530d2c5c83ac7 author : Andrew Dunstan <andrew@dunslane.net> date : Thu, 10 Feb 2022 13:44:05 -0500 committer: Andrew Dunstan <andrew@dunslane.net> date : Thu, 10 Feb 2022 13:44:05 -0500 Click here for diff Modern msys systems lack pexports but have gendef instead, so use that. Discussion: https://postgr.es/m/3ccde7a9-e4f9-e194-30e0-0936e6ad68ba@dunslane.net Backpatch to release 9.4 to enable building with perl on older branches.

PostgreSQL 10.20 commit log

Stamp 10.20. commit : fa362d2b3bde0f99ba8a22486205de11b2e00e14 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Feb 2022 16:21:57 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Feb 2022 16:21:57 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : 217257fac07426cf4c0c2def14f1cb19c330d36a author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Feb 2022 13:53:57 +0100 committer: Peter Eisentraut <peter@eisentraut.

PostgreSQL 11.15 commit log

Stamp 11.15. commit : ff2a6d2621439d3d3f6e340c363d3b5e71749919 author : Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Feb 2022 16:20:23 -0500 committer: Tom Lane <tgl@sss.pgh.pa.us> date : Mon, 7 Feb 2022 16:20:23 -0500 Click here for diff M configure M configure.in M doc/bug.template M src/include/pg_config.h.win32 M src/interfaces/libpq/libpq.rc.in M src/port/win32ver.rc Translation updates commit : d793dcf28b5dc6da4a76cbf3c059b36c2c8763f4 author : Peter Eisentraut <peter@eisentraut.org> date : Mon, 7 Feb 2022 13:51:36 +0100 committer: Peter Eisentraut <peter@eisentraut.