pgsql: Use replay LSN as target for cascading logical WAL senders

2025-06-01 Thread Michael Paquier
Use replay LSN as target for cascading logical WAL senders A cascading WAL sender doing logical decoding (as known as doing its work on a standby) has been using as flush LSN the value returned by GetStandbyFlushRecPtr() (last position safely flushed to disk). This is incorrect as such processes

pgsql: Use replay LSN as target for cascading logical WAL senders

2025-06-01 Thread Michael Paquier
Use replay LSN as target for cascading logical WAL senders A cascading WAL sender doing logical decoding (as known as doing its work on a standby) has been using as flush LSN the value returned by GetStandbyFlushRecPtr() (last position safely flushed to disk). This is incorrect as such processes

pgsql: Use replay LSN as target for cascading logical WAL senders

2025-06-01 Thread Michael Paquier
Use replay LSN as target for cascading logical WAL senders A cascading WAL sender doing logical decoding (as known as doing its work on a standby) has been using as flush LSN the value returned by GetStandbyFlushRecPtr() (last position safely flushed to disk). This is incorrect as such processes

pgsql: Rename gist stratnum support function

2025-06-01 Thread Peter Eisentraut
Rename gist stratnum support function Commit 7406ab623fe added a gist support function that we internally refer to by the symbol GIST_STRATNUM_PROC. This translated from "well-known" strategy numbers to opfamily-specific strategy numbers. However, we later (commit 630f9a43cec) changed this to fit

pgsql: postgres_fdw: Inherit the local transaction's access/deferrable

2025-06-01 Thread Etsuro Fujita
postgres_fdw: Inherit the local transaction's access/deferrable modes. Previously, postgres_fdw always 1) opened a remote transaction in READ WRITE mode even when the local transaction was READ ONLY, causing a READ ONLY transaction using it that references a foreign table mapped to a remote view e

pgsql: Fix edge-case resource leaks in PL/Python error reporting.

2025-06-01 Thread Tom Lane
Fix edge-case resource leaks in PL/Python error reporting. PLy_elog_impl and its subroutine PLy_traceback intended to avoid leaking any PyObject reference counts, but their coverage of the matter was sadly incomplete. In particular, out-of-memory errors in most of the string-construction subrouti

pgsql: Run pgindent on the previous commit.

2025-06-01 Thread Tom Lane
Run pgindent on the previous commit. Clean up after rearranging PG_TRY blocks. Author: Tom Lane Discussion: https://postgr.es/m/2954090.1748723...@sss.pgh.pa.us Backpatch-through: 13 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4672b6223910687b2aab075bcd2dd54ce

pgsql: Fix edge-case resource leaks in PL/Python error reporting.

2025-06-01 Thread Tom Lane
Fix edge-case resource leaks in PL/Python error reporting. PLy_elog_impl and its subroutine PLy_traceback intended to avoid leaking any PyObject reference counts, but their coverage of the matter was sadly incomplete. In particular, out-of-memory errors in most of the string-construction subrouti

pgsql: Fix edge-case resource leaks in PL/Python error reporting.

2025-06-01 Thread Tom Lane
Fix edge-case resource leaks in PL/Python error reporting. PLy_elog_impl and its subroutine PLy_traceback intended to avoid leaking any PyObject reference counts, but their coverage of the matter was sadly incomplete. In particular, out-of-memory errors in most of the string-construction subrouti

pgsql: Fix edge-case resource leaks in PL/Python error reporting.

2025-06-01 Thread Tom Lane
Fix edge-case resource leaks in PL/Python error reporting. PLy_elog_impl and its subroutine PLy_traceback intended to avoid leaking any PyObject reference counts, but their coverage of the matter was sadly incomplete. In particular, out-of-memory errors in most of the string-construction subrouti

pgsql: Run pgindent on the previous commit.

2025-06-01 Thread Tom Lane
Run pgindent on the previous commit. Clean up after rearranging PG_TRY blocks. Author: Tom Lane Discussion: https://postgr.es/m/2954090.1748723...@sss.pgh.pa.us Backpatch-through: 13 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/93aca12461686d5fe66b07099e

pgsql: Run pgindent on the previous commit.

2025-06-01 Thread Tom Lane
Run pgindent on the previous commit. Clean up after rearranging PG_TRY blocks. Author: Tom Lane Discussion: https://postgr.es/m/2954090.1748723...@sss.pgh.pa.us Backpatch-through: 13 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b898bb2a79ae1f2d54f3d21a22

pgsql: Run pgindent on the previous commit.

2025-06-01 Thread Tom Lane
Run pgindent on the previous commit. Clean up after rearranging PG_TRY blocks. Author: Tom Lane Discussion: https://postgr.es/m/2954090.1748723...@sss.pgh.pa.us Backpatch-through: 13 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ecc8fd2b77635b43c034359c9a

pgsql: Fix edge-case resource leaks in PL/Python error reporting.

2025-06-01 Thread Tom Lane
Fix edge-case resource leaks in PL/Python error reporting. PLy_elog_impl and its subroutine PLy_traceback intended to avoid leaking any PyObject reference counts, but their coverage of the matter was sadly incomplete. In particular, out-of-memory errors in most of the string-construction subrouti

pgsql: Run pgindent on the previous commit.

2025-06-01 Thread Tom Lane
Run pgindent on the previous commit. Clean up after rearranging PG_TRY blocks. Author: Tom Lane Discussion: https://postgr.es/m/2954090.1748723...@sss.pgh.pa.us Backpatch-through: 13 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6f724fcf8136dc4c229e66122f

pgsql: Fix edge-case resource leaks in PL/Python error reporting.

2025-06-01 Thread Tom Lane
Fix edge-case resource leaks in PL/Python error reporting. PLy_elog_impl and its subroutine PLy_traceback intended to avoid leaking any PyObject reference counts, but their coverage of the matter was sadly incomplete. In particular, out-of-memory errors in most of the string-construction subrouti

pgsql: Run pgindent on the previous commit.

2025-06-01 Thread Tom Lane
Run pgindent on the previous commit. Clean up after rearranging PG_TRY blocks. Author: Tom Lane Discussion: https://postgr.es/m/2954090.1748723...@sss.pgh.pa.us Backpatch-through: 13 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d4556f592eff4829012e3df72c

pgsql: Add commit 4672b6223 to .git-blame-ignore-revs.

2025-06-01 Thread Tom Lane
Add commit 4672b6223 to .git-blame-ignore-revs. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c98975ba85f64ad95368575cf419813bfb8027b0 Modified Files -- .git-blame-ignore-revs | 3 +++ 1 file changed, 3 insertions(+)