pgsql: Add HINT for COPY TO when WHERE clause is used.

Add HINT for COPY TO when WHERE clause is used. COPY TO does not support a WHERE clause, and currently fails with the error: ERROR: WHERE clause not allowed with COPY TO Since the intended behavior can be achieved by using COPY (SELECT ... WHERE ...) TO, this commit adds a HINT to the error

pgsql: Disallow server start with sync_replication_slots = on and wal_l

or replica. Failing early during startup helps users catch invalid configurations immediately, which is important because changing wal_level requires a server restart. Author: Fujii Masao Reviewed-by: Shveta Malik Discussion: https://postgr.es/m/cah0ptu_pc3ohi__xesf9zigcyzai1mo3lsodfyqa4aud

pgsql: vacuumdb: Make vacuumdb --analyze-only process partitioned table

views, but not foreign tables. Because this is a nontrivial behavior change, it is applied only to master. Reported-by: Zechman, Derek S Author: Laurenz Albe Co-authored-by: Mircea Cadariu Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CO1PR04MB8281387B9AD9DE30976966BBC045A

pgsql: doc: Improve pgoutput documentation.

pg_logical_slot_peek_changes and pg_logical_slot_get_changes with pgoutput. Author: Fujii Masao Reviewed-by: Chao Li Reviewed-by: Hayato Kuroda Discussion: https://postgr.es/m/CAHGQGwFJTbygdhhjR_iP4Oem=lo1xsptwwoq825uow+hg_l...@mail.gmail.com Branch -- master Details --- https

pgsql: doc: Improve documentation discoverability for pgoutput.

moves the pgoutput documentation under the logical decoding section and adds an index entry, making it easier for users to locate and access this information. Author: Fujii Masao Reviewed-by: Chao Li Reviewed-by: Hayato Kuroda Reviewed-by: Euler Taveira Discussion: https://postgr.es/m

pgsql: Revert logical snapshot filename format change in SnapBuildSnaps

Revert logical snapshot filename format change in SnapBuildSnapshotExists(). Commit 2633dae2e48 standardized LSN formatting but mistakenly changed the logical snapshot filename format in SnapBuildSnapshotExists() from "%X-%X.snap" to "%08X-%08X.snap". Other code still used the original "%X-%X.snap

pgsql: Fix incorrect LSN format in comment.

Fix incorrect LSN format in comment. The comment previously used %X/08X, which is wrong. Updated it to the standardized format %X/%08X. Author: Japin Li Discussion: https://postgr.es/m/me0p300mb0445a37908efccd15e6d749db6...@me0p300mb0445.ausp300.prod.outlook.com Branch -- master Details -

pgsql: pg_dump: Fix incorrect parsing of object types in pg_dump --filt

uot; was parsed as "table". To fix this, pg_dump --filter now treats keywords as strings of non-whitespace characters, ensuring invalid types like "table-data" are correctly rejected. Back-patch to v17, where the --filter option was introduced. Author: Fujii Masao Reviewed-by:

pgsql: pg_dump: Fix incorrect parsing of object types in pg_dump --filt

uot; was parsed as "table". To fix this, pg_dump --filter now treats keywords as strings of non-whitespace characters, ensuring invalid types like "table-data" are correctly rejected. Back-patch to v17, where the --filter option was introduced. Author: Fujii Masao Reviewed-by:

pgsql: pg_dump: Fix incorrect parsing of object types in pg_dump --filt

uot; was parsed as "table". To fix this, pg_dump --filter now treats keywords as strings of non-whitespace characters, ensuring invalid types like "table-data" are correctly rejected. Back-patch to v17, where the --filter option was introduced. Author: Fujii Masao Reviewed-by:

pgsql: Fix typo in comment.

Fix typo in comment. Author: Chao Li Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/cd9b2247-617a-4761-8338-2705c8728...@highgo.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/99139c46cbf2bda7880592c4e5da1ebf177888ac Modified Files

pgsql: doc: Recommend ANALYZE after ALTER TABLE ... SET EXPRESSION AS.

lumns to v18 where those columns were added. Author: Yugo Nagata Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/20250804151418.0cf365bd2855d60676344...@sraoss.co.jp Backpatch-through: 17 Branch -- REL_18_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: doc: Recommend ANALYZE after ALTER TABLE ... SET EXPRESSION AS.

lumns to v18 where those columns were added. Author: Yugo Nagata Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/20250804151418.0cf365bd2855d60676344...@sraoss.co.jp Backpatch-through: 17 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commi

pgsql: doc: Recommend ANALYZE after ALTER TABLE ... SET EXPRESSION AS.

lumns to v18 where those columns were added. Author: Yugo Nagata Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/20250804151418.0cf365bd2855d60676344...@sraoss.co.jp Backpatch-through: 17 Branch -- master Details --- https://git.postgresql.org/pg/commi

pgsql: Avoid unexpected shutdown when sync_replication_slots is enabled

continue running even with the misconfiguration. Back-patch to v17, where slot synchronization was introduced. Reported-by: Hugo DUBOIS Author: Fujii Masao Reviewed-by: Hugo DUBOIS Reviewed-by: Shveta Malik Discussion: https://postgr.es/m/cah0ptu_pc3ohi__xesf9zigcyzai1mo3lsodfyqa4audkm0

pgsql: Avoid unexpected shutdown when sync_replication_slots is enabled

continue running even with the misconfiguration. Back-patch to v17, where slot synchronization was introduced. Reported-by: Hugo DUBOIS Author: Fujii Masao Reviewed-by: Hugo DUBOIS Reviewed-by: Shveta Malik Discussion: https://postgr.es/m/cah0ptu_pc3ohi__xesf9zigcyzai1mo3lsodfyqa4audkm0

pgsql: Avoid unexpected shutdown when sync_replication_slots is enabled

continue running even with the misconfiguration. Back-patch to v17, where slot synchronization was introduced. Reported-by: Hugo DUBOIS Author: Fujii Masao Reviewed-by: Hugo DUBOIS Reviewed-by: Shveta Malik Discussion: https://postgr.es/m/cah0ptu_pc3ohi__xesf9zigcyzai1mo3lsodfyqa4audkm0

pgsql: Fix assertion failure in pgbench when handling multiple pipeline

pgbench to correctly process multiple pipeline sync messages, preventing the assertion failure. Back-patch to v15, where the bug was introduced. Author: Fujii Masao Reviewed-by: Tatsuo Ishii Discussion: https://postgr.es/m/cahgqgwfax56tfx+1ppo431oswilluw72hagzz39nklkop6b...@mail.gmail.com Backpatch

pgsql: Fix assertion failure in pgbench when handling multiple pipeline

pgbench to correctly process multiple pipeline sync messages, preventing the assertion failure. Back-patch to v15, where the bug was introduced. Author: Fujii Masao Reviewed-by: Tatsuo Ishii Discussion: https://postgr.es/m/cahgqgwfax56tfx+1ppo431oswilluw72hagzz39nklkop6b...@mail.gmail.com Backpatch

pgsql: Fix assertion failure in pgbench when handling multiple pipeline

pgbench to correctly process multiple pipeline sync messages, preventing the assertion failure. Back-patch to v15, where the bug was introduced. Author: Fujii Masao Reviewed-by: Tatsuo Ishii Discussion: https://postgr.es/m/cahgqgwfax56tfx+1ppo431oswilluw72hagzz39nklkop6b...@mail.gmail.com Backpatch

pgsql: Fix assertion failure in pgbench when handling multiple pipeline

pgbench to correctly process multiple pipeline sync messages, preventing the assertion failure. Back-patch to v15, where the bug was introduced. Author: Fujii Masao Reviewed-by: Tatsuo Ishii Discussion: https://postgr.es/m/cahgqgwfax56tfx+1ppo431oswilluw72hagzz39nklkop6b...@mail.gmail.com Backpatch

pgsql: Fix assertion failure in pgbench when handling multiple pipeline

pgbench to correctly process multiple pipeline sync messages, preventing the assertion failure. Back-patch to v15, where the bug was introduced. Author: Fujii Masao Reviewed-by: Tatsuo Ishii Discussion: https://postgr.es/m/cahgqgwfax56tfx+1ppo431oswilluw72hagzz39nklkop6b...@mail.gmail.com Backpatch

pgsql: Add regression test for background worker restart after crash.

the never-restart flag are correctly restarted after a crash-and-restart cycle. To guard against regressions, this commit adds a test that verifies a background worker successfully restarts in such a scenario. Author: Fujii Masao Reviewed-by: ChangAo Chen Discussion: https://postgr.es/m

pgsql: Fix background worker not restarting after crash-and-restart cyc

: Fujii Masao Reviewed-by: ChangAo Chen Reviewed-by: Shveta Malik Discussion: https://postgr.es/m/CAF6JsWiO=i24qyitwe6ns1sxqcl86ryxdyu+pnyk-wuekps...@mail.gmail.com Discussion: https://postgr.es/m/tencent_e00a056b3953ee6440f0f40f80ec30427...@qq.com Backpatch-through: 18 Branch -- REL_18_STABLE

pgsql: Fix background worker not restarting after crash-and-restart cyc

: Fujii Masao Reviewed-by: ChangAo Chen Reviewed-by: Shveta Malik Discussion: https://postgr.es/m/CAF6JsWiO=i24qyitwe6ns1sxqcl86ryxdyu+pnyk-wuekps...@mail.gmail.com Discussion: https://postgr.es/m/tencent_e00a056b3953ee6440f0f40f80ec30427...@qq.com Backpatch-through: 18 Branch -- master

pgsql: doc: Add missing index entries and fix title formatting in pg_bu

after function names where they were previously missing. Author: Fujii Masao Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/7d19af4b-7da3-4862-9f52-ff958960b...@oss.nttdata.com Backpatch-through: 18 Branch -- REL_18_STABLE Details --- https://git.postgresql.org/pg

pgsql: doc: Add missing index entries and fix title formatting in pg_bu

after function names where they were previously missing. Author: Fujii Masao Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/7d19af4b-7da3-4862-9f52-ff958960b...@oss.nttdata.com Backpatch-through: 18 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff

pgsql: Remove translation marker from libpq-be-fe-helpers.h.

this, a gettext_noop() call was also found in contrib/basic_archive. Since contrib modules don't support translation, this call has been removed as well. Per buildfarm member indri. Author: Fujii Masao Reviewed-by: Álvaro Herrera Discussion: https://postgr.es/m/0e6299d9-608a-4ffa-aeb1-40cb

pgsql: Log remote NOTICE, WARNING, and similar messages using ereport()

appear in the logs with proper formatting and context, which improves clarity and aids in debugging. Author: Vignesh C Reviewed-by: Álvaro Herrera Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/caldanm2xshpwrtlm-vl_hjcsae3+1y_n-jdear3-suxvqc3...@mail.gmail.com Branch -- master

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_13_STABLE

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_14_STABLE

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_15_STABLE

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_16_STABLE

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_17_STABLE

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_18_STABLE

pgsql: doc: Document reopen of output file via SIGHUP in pg_recvlogical

was previously undocumented. This commit adds the missing documentation. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Shinya Kato Discussion: https://postgr.es/m/0977fc4f-1523-4ecd-8a0e-391af4976...@oss.nttdata.com Backpatch-through: 13 Branch -- master Details

pgsql: pgoutput: Initialize missing default for "origin" parameter.

tion of the "origin" parameter to ensure consistency and clarity in how defaults are handled. Author: Fujii Masao Reviewed-by: Euler Taveira Discussion: https://postgr.es/m/d2790f10-238d-4cb5-a743-d9d2a9dd9...@oss.nttdata.com Branch -- master Detail

pgsql: doc: Document default values for pgoutput options in protocol.sg

those options to use pg_recvlogical with pgoutput plugin. This commit adds the explanations of the default values for pgoutput options to improve clarity and usability. Author: Fujii Masao Reviewed-by: Euler Taveira Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/d2790f10-238d-4cb5

pgsql: doc: Fix confusing description of streaming option in START_REPL

emove the "boolean" reference and clearly list the valid values for the streaming option. Back-patch to v16, where the streaming option changed to a non-boolean. Author: Euler Taveira Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/8d21fb98-5c25-4dee-8387-e5a62b01e...@a

pgsql: doc: Fix confusing description of streaming option in START_REPL

emove the "boolean" reference and clearly list the valid values for the streaming option. Back-patch to v16, where the streaming option changed to a non-boolean. Author: Euler Taveira Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/8d21fb98-5c25-4dee-8387-e5a62b01e...@a

pgsql: doc: Fix confusing description of streaming option in START_REPL

emove the "boolean" reference and clearly list the valid values for the streaming option. Back-patch to v16, where the streaming option changed to a non-boolean. Author: Euler Taveira Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/8d21fb98-5c25-4dee-8387-e5a62b01e...@a

pgsql: doc: Fix confusing description of streaming option in START_REPL

emove the "boolean" reference and clearly list the valid values for the streaming option. Back-patch to v16, where the streaming option changed to a non-boolean. Author: Euler Taveira Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/8d21fb98-5c25-4dee-8387-e5a62b01e...@a

pgsql: doc: Clarify that total_vacuum_time excludes VACUUM FULL.

also excludes VACUUM FULL. Although n_ins_since_vacuum was added in v13, we are not back-patching this change to stable branches, as it is a documentation improvement, not a bug fix. Author: Fujii Masao Reviewed-by: Robert Treat Reviewed-by: David G. Johnston Reviewed-by: Laurenz Albe

pgsql: doc: Clarify that total_vacuum_time excludes VACUUM FULL.

also excludes VACUUM FULL. Although n_ins_since_vacuum was added in v13, we are not back-patching this change to stable branches, as it is a documentation improvement, not a bug fix. Author: Fujii Masao Reviewed-by: Robert Treat Reviewed-by: David G. Johnston Reviewed-by: Laurenz Albe

pgsql: psql: Fix tab-completion after GRANT/REVOKE on LARGE OBJECT and

id at that point. This commit fixes the issue by preventing TO and FROM from being offered immediately after those specific GRANT/REVOKE statements. Author: Yugo Nagata Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/20250408122857.b2b06dde4e6a08290af02...@sraoss.co.jp Branch -- m

pgsql: amcheck: Improve error message for partitioned index target.

E_STATE, aligning with usage in similar modules like pgstattuple. Author: Masahiro Ikeda Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/8829854bbfc8635ddecd0846bb72d...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/88a658a42e1b3e6b1a6d

pgsql: doc: Clarify meaning of "idle" in idle_replication_slot_timeout.

ling Reviewed-by: Amit Kapila Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CADGJaX_0+FTguWpNSpgVWYQP_7MhoO0D8=cp4xozsqgaz40...@mail.gmail.com Backpatch-through: 18 Branch -- REL_18_STABLE Details --- https://git.postgresql.org/pg/commitdiff/afb64a56d9c13d0bcd32c00e9a

pgsql: doc: Clarify meaning of "idle" in idle_replication_slot_timeout.

ling Reviewed-by: Amit Kapila Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CADGJaX_0+FTguWpNSpgVWYQP_7MhoO0D8=cp4xozsqgaz40...@mail.gmail.com Backpatch-through: 18 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/110e6dcaa6595cf71be00808e3

pgsql: Change unit of idle_replication_slot_timeout to seconds.

standard time suffixes, for example, '24h' for 24 hours. Back-patch to v18 where idle_replication_slot_timeout was added. Reported-by: Gunnar Morling Author: Fujii Masao Reviewed-by: Laurenz Albe Reviewed-by: David G. Johnston Reviewed-by: Amit Kapila Reviewed-by: Hayato Kuroda Review

pgsql: Change unit of idle_replication_slot_timeout to seconds.

standard time suffixes, for example, '24h' for 24 hours. Back-patch to v18 where idle_replication_slot_timeout was added. Reported-by: Gunnar Morling Author: Fujii Masao Reviewed-by: Laurenz Albe Reviewed-by: David G. Johnston Reviewed-by: Amit Kapila Reviewed-by: Hayato Kuroda Review

pgsql: psql: Improve psql tab completion for GRANT/REVOKE on large obje

s also updated for "GRANT/REVOKE ... ON LARGE OBJECTS" with TO/FROM. Author: Fujii Masao Reviewed-by: Yugo Nagata Discussion: https://postgr.es/m/ade0ab29-777f-47f6-9d0d-1af67728a...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/86c53

pgsql: amcheck: Remove unused IndexCheckableCallback typedef.

amcheck: Remove unused IndexCheckableCallback typedef. Commit d70b17636dd introduced the IndexCheckableCallback typedef for a callback function, but it was never used. This commit removes the unused typedef to clean up dead code. Author: Fujii Masao Reviewed-by: Andrey Borodin Discussion

pgsql: Speed up truncation of temporary relations.

ichael Paquier Reviewed-by: Fujii Masao Reviewed-by: Dilip Kumar Reviewed-by: Maxim Orlov Discussion: https://postgr.es/m/CAJDiXggNqsJOH7C5co4jA8nDk8vw-=sokyh5s1_tenwnc6o...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/comm

pgsql: Remove leftover dead code from commit_ts.h.

is applied only to the master branch. Author: Andy Fan Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/87ecuzmkqf@163.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c84698ceaea8a08b1d11d527ce9530a98b156799 Modified Files -- src

pgsql: doc: Update outdated descriptions of wal_status in pg_replicatio

v16, where the additional invalidation cases were introduced. Author: Fujii Masao Reviewed-by: Hayato Kuroda Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/78b34e84-2195-4f28-a151-5d204a382...@oss.nttdata.com Backpatch-through: 16 Branch -- REL_16_STABLE Details --- https

pgsql: doc: Update outdated descriptions of wal_status in pg_replicatio

v16, where the additional invalidation cases were introduced. Author: Fujii Masao Reviewed-by: Hayato Kuroda Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/78b34e84-2195-4f28-a151-5d204a382...@oss.nttdata.com Backpatch-through: 16 Branch -- REL_17_STABLE Details --- https

pgsql: doc: Update outdated descriptions of wal_status in pg_replicatio

v16, where the additional invalidation cases were introduced. Author: Fujii Masao Reviewed-by: Hayato Kuroda Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/78b34e84-2195-4f28-a151-5d204a382...@oss.nttdata.com Backpatch-through: 16 Branch -- REL_18_STABLE Details --- https

pgsql: doc: Update outdated descriptions of wal_status in pg_replicatio

v16, where the additional invalidation cases were introduced. Author: Fujii Masao Reviewed-by: Hayato Kuroda Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/78b34e84-2195-4f28-a151-5d204a382...@oss.nttdata.com Backpatch-through: 16 Branch -- master Details --- https

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_13_STABLE Details --- https://git.postgre

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_14_STABLE Details --- https://git.postgre

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_15_STABLE Details --- https://git.postgre

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_16_STABLE Details --- https://git.postgre

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_17_STABLE Details --- https://git.postgre

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- REL_18_STABLE Details --- https://git.postgre

pgsql: doc: Remove incorrect note about wal_status in pg_replication_sl

it removes the incorrect description. Back-patched to all supported versions. Author: Fujii Masao Reviewed-by: Nisha Moond Discussion: https://postgr.es/m/c9d23cdc-b5dd-455a-8ee9-f1f24d701...@oss.nttdata.com Backpatch-through: 13 Branch -- master Details --- https://git.postgre

pgsql: Support multi-line headers in COPY FROM command.

Co-authored-by: Fujii Masao Reviewed-by: Yugo Nagata Discussion: https://postgr.es/m/CAOzEurRPxfzbxqeOPF_AGnAUOYf=wk0we+1lqompnuntyzg...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/bc2f348e87c02de63647dbe290d64ff00dbe Modified Files

pgsql: psql: Improve tab completion for COPY command.

completion for COPY to also include materialized views and foreign tables. Views with INSTEAD OF INSERT triggers are supported with COPY FROM but rarely used, so plain views are intentionally excluded from completion. Author: jian he Co-authored-by: Fujii Masao Reviewed-by: Kirill Reshke Reviewed-by

pgsql: Make CREATE TABLE LIKE copy comments on NOT NULL constraints whe

commit corrects the behavior by ensuring CREATE TABLE LIKE to also copy the comments on NOT NULL constraints when INCLUDING COMMENTS is specified. Author: Jian He Co-authored-by: Álvaro Herrera Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/127debef-e558-4784-9e24-0d5eaf91e

pgsql: doc: Fix incorrect UUID index entry in function documentation.

linking to itself. This commit updates the UUID index entry in the UUID functions documentation to point to the correct section, improving navigation and avoiding duplication. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Masahiko Sawada Reviewed-by: Daniel Gustafsson

pgsql: doc: Fix incorrect UUID index entry in function documentation.

linking to itself. This commit updates the UUID index entry in the UUID functions documentation to point to the correct section, improving navigation and avoiding duplication. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Masahiko Sawada Reviewed-by: Daniel Gustafsson

pgsql: doc: Add secondary index entries for vacuum-related parameters.

missing for vacuum_truncate and vacuum_max_eager_freeze_failure_rate, both introduced in v18. This commit adds appropriate secondary index terms for these parameters to ensure consistency with other parameters and improve usability of the documentation index. Author: Fujii Masao Discussion

pgsql: doc: Fix type description of io_workers GUC for consistency.

ion of io_workers to "integer" for consistency with other GUC parameter descriptions. Author: Fujii Masao Discussion: https://postgr.es/m/e95c899a-2aeb-45b7-8fd3-7a27dcdb4...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/82015fd9bdc0827c3324

pgsql: doc: Mention ANALYZE VERBOSE in track_cost_delay_timing descript

previously omitted from the list. This commit updates the documentation to include ANALYZE VERBOSE in the list, clarifying that it also reports cost-based delay timing information. Author: Fujii Masao Discussion: https://postgr.es/m/e95c899a-2aeb-45b7-8fd3-7a27dcdb4...@oss.nttdata.com Branch

pgsql: doc: Fix incorrect UUID index entry in function documentation.

linking to itself. This commit updates the UUID index entry in the UUID functions documentation to point to the correct section, improving navigation and avoiding duplication. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Masahiko Sawada Reviewed-by: Daniel Gustafsson

pgsql: doc: Fix incorrect UUID index entry in function documentation.

linking to itself. This commit updates the UUID index entry in the UUID functions documentation to point to the correct section, improving navigation and avoiding duplication. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Masahiko Sawada Reviewed-by: Daniel Gustafsson

pgsql: doc: Fix incorrect UUID index entry in function documentation.

linking to itself. This commit updates the UUID index entry in the UUID functions documentation to point to the correct section, improving navigation and avoiding duplication. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Masahiko Sawada Reviewed-by: Daniel Gustafsson

pgsql: doc: Fix incorrect UUID index entry in function documentation.

linking to itself. This commit updates the UUID index entry in the UUID functions documentation to point to the correct section, improving navigation and avoiding duplication. Back-patch to all supported versions. Author: Fujii Masao Reviewed-by: Masahiko Sawada Reviewed-by: Daniel Gustafsson

pgsql: doc: Mention GIN indexes support parallel builds.

updates those references to correctly include GIN indexes. Author: Fujii Masao Reviewed-by: Robert Treat Discussion: https://postgr.es/m/7d27d068-90e2-4022-9bd7-09b0fd3d4...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff

pgsql: doc: Fix incorrect description of INCLUDING COMMENTS in CREATE F

stated that index comments would be copied when using INCLUDING COMMENTS. This commit corrects that by removing the mention of index comments. Author: Fujii Masao Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/f86cd84f-a6a3-4451-bae7-5cca9e63b...@oss.nttdata.com Branch -- master

pgsql: pg_dump: Allow pg_dump to dump the statistics for foreign tables

() support them. This commit fixes that oversight by allowing pg_dump and pg_dumpall to include statistics for foreign tables. Author: Fujii Masao Reviewed-by: Corey Huinker Reviewed-by: Nathan Bossart Discussion: https://postgr.es/m/3772e4e4-ef39-4deb-bb76-aa8165f33...@oss.nttdata.com Branch

pgsql: doc: Reorder protocol version option descriptions in libpq docs.

entries. This commit moves the min_protocol_version and max_protocol_version descriptions to appear after the SSL-related options. This improves the logical order and makes it easier for users to locate the relevant settings in the libpq documentation. Author: Fujii Masao Reviewed-by: Jelte Fennema

pgsql: doc: Add note about "Client User" and "Superuser" fields in \con

t execution context is a superuser. This means the users referred to in these columns can differ, for example, if the current user was changed with the SET ROLE command. This commit adds a note to the \conninfo documentation to clarify this behavior and avoid potential confusion. Author: Fujii Ma

pgsql: psql: Report full protocol version in \conninfo output.

patch and is included in v18. Author: Fujii Masao Reviewed-by: David G. Johnston Discussion: https://postgr.es/m/685961b8-b6ce-40bb-b2d5-c2ff135d3...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/be37ac20fc23511c49b9c56567c7c707b73d10b0 Mod

pgsql: pg_restore: Fix wrong descriptions of --with-{schema,data,statis

message and documentation incorrectly described them as affecting what gets dumped. This commit corrects those descriptions to clarify that the options control restoration, not dumping. Bug: #18952 Reported-by: TAKATSUKA Haruka Author: Fujii Masao Reviewed-by: TAKATSUKA Haruka Reviewed-by: Daniel

pgsql: doc: Document that MAINTAIN privilege allows statistics manipula

allowed operations. This commit updates the MAINTAIN privilege documentation to explicitly include statistics manipulation functions, clarifying what the privilege covers. Author: Fujii Masao Reviewed-by: Robert Treat Discussion: https://postgr.es/m/7c7e1ad5-fdf9-486f-bc63-40ac99b04

pgsql: Rename log_lock_failure GUC to log_lock_failures for consistency

Eisentraut Author: Fujii Masao Discussion: https://postgr.es/m/7a8198b6-d5b8-4910-b41e-8d3efcbb0...@eisentraut.org Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/73bdcfab35ec0a7eff1a5dd630cbad8e77054547 Modified Files -- doc/src/sgml/config.sgml

pgsql: Make XactLockTableWait() and ConditionalXactLockTableWait() inte

absence of CHECK_FOR_INTERRUPTS() within it. This commit adds CHECK_FOR_INTERRUPTS() to the loop in both functions, ensuring they can be interrupted safely. Back-patch to all supported branches. Author: Kevin K Biju Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAM45KeELdjhS-rGuvN

pgsql: Make XactLockTableWait() and ConditionalXactLockTableWait() inte

absence of CHECK_FOR_INTERRUPTS() within it. This commit adds CHECK_FOR_INTERRUPTS() to the loop in both functions, ensuring they can be interrupted safely. Back-patch to all supported branches. Author: Kevin K Biju Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAM45KeELdjhS-rGuvN

pgsql: Make XactLockTableWait() and ConditionalXactLockTableWait() inte

absence of CHECK_FOR_INTERRUPTS() within it. This commit adds CHECK_FOR_INTERRUPTS() to the loop in both functions, ensuring they can be interrupted safely. Back-patch to all supported branches. Author: Kevin K Biju Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAM45KeELdjhS-rGuvN

pgsql: Make XactLockTableWait() and ConditionalXactLockTableWait() inte

absence of CHECK_FOR_INTERRUPTS() within it. This commit adds CHECK_FOR_INTERRUPTS() to the loop in both functions, ensuring they can be interrupted safely. Back-patch to all supported branches. Author: Kevin K Biju Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAM45KeELdjhS-rGuvN

pgsql: Make XactLockTableWait() and ConditionalXactLockTableWait() inte

absence of CHECK_FOR_INTERRUPTS() within it. This commit adds CHECK_FOR_INTERRUPTS() to the loop in both functions, ensuring they can be interrupted safely. Back-patch to all supported branches. Author: Kevin K Biju Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAM45KeELdjhS-rGuvN

pgsql: Make XactLockTableWait() and ConditionalXactLockTableWait() inte

absence of CHECK_FOR_INTERRUPTS() within it. This commit adds CHECK_FOR_INTERRUPTS() to the loop in both functions, ensuring they can be interrupted safely. Back-patch to all supported branches. Author: Kevin K Biju Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/CAM45KeELdjhS-rGuvN

pgsql: Fix assertion failure in pg_prewarm() on objects without storage

is similar to the fix in commit 4623d7144 for pg_freespacemap. Back-patched to v17, where the issue was introduced. Author: Masahiro Ikeda Reviewed-by: Dilip Kumar Reviewed-by: Richard Guo Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/e082e6027610fd0a4091ae6d033aa...@oss.nttdata.com

pgsql: Fix assertion failure in pg_prewarm() on objects without storage

is similar to the fix in commit 4623d7144 for pg_freespacemap. Back-patched to v17, where the issue was introduced. Author: Masahiro Ikeda Reviewed-by: Dilip Kumar Reviewed-by: Richard Guo Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/e082e6027610fd0a4091ae6d033aa...@oss.nttdata.com

pgsql: doc: Fix documenation for snapshot export in logical decoding.

updates the documentation for v15 and later to use the modern equivalent: SNAPSHOT 'nothing'. The older syntax is preserved in documentation for v14 and earlier. Back-patched to all supported branches. Reported-by: Kevin K Biju Author: Fujii Masao Reviewed-by: Kevin K Biju Discussi

pgsql: doc: Fix documenation for snapshot export in logical decoding.

updates the documentation for v15 and later to use the modern equivalent: SNAPSHOT 'nothing'. The older syntax is preserved in documentation for v14 and earlier. Back-patched to all supported branches. Reported-by: Kevin K Biju Author: Fujii Masao Reviewed-by: Kevin K Biju Discussi

pgsql: doc: Fix documenation for snapshot export in logical decoding.

updates the documentation for v15 and later to use the modern equivalent: SNAPSHOT 'nothing'. The older syntax is preserved in documentation for v14 and earlier. Back-patched to all supported branches. Reported-by: Kevin K Biju Author: Fujii Masao Reviewed-by: Kevin K Biju Discussi

pgsql: doc: Fix documenation for snapshot export in logical decoding.

updates the documentation for v15 and later to use the modern equivalent: SNAPSHOT 'nothing'. The older syntax is preserved in documentation for v14 and earlier. Back-patched to all supported branches. Reported-by: Kevin K Biju Author: Fujii Masao Reviewed-by: Kevin K Biju Discussi

pgsql: doc: Fix documenation for snapshot export in logical decoding.

updates the documentation for v15 and later to use the modern equivalent: SNAPSHOT 'nothing'. The older syntax is preserved in documentation for v14 and earlier. Back-patched to all supported branches. Reported-by: Kevin K Biju Author: Fujii Masao Reviewed-by: Kevin K Biju Discussi

pgsql: doc: Fix documenation for snapshot export in logical decoding.

updates the documentation for v15 and later to use the modern equivalent: SNAPSHOT 'nothing'. The older syntax is preserved in documentation for v14 and earlier. Back-patched to all supported branches. Reported-by: Kevin K Biju Author: Fujii Masao Reviewed-by: Kevin K Biju Discussi

  1   2   3   4   5   6   7   8   >