pgsql: doc PG 17 relnotes: adjust IN wording

2024-05-27 Thread Bruce Momjian
doc PG 17 relnotes: adjust IN wording Reported-by: David Rowley Discussion: https://postgr.es/m/CAApHDvqmW0wQRam4paRbHvLQA+w5CJOCno4BCu=nfrlrhyh...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: improve btree "set/array" matching item

2024-05-25 Thread Bruce Momjian
doc PG 17 relnotes: improve btree "set/array" matching item Reported-by: Peter Geoghegan Discussion: https://postgr.es/m/cah2-wznwss5iruka2deuoosdh7sts2opdvv4pcowhk51fq2...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: fix "pg_stat_slru_reset" wording

2024-05-25 Thread Bruce Momjian
doc PG 17 relnotes: fix "pg_stat_slru_reset" wording Reported-by: Marcos Pegoraro Discussion: https://postgr.es/m/cab-jlwyxrl-8fbfvdx8tevytj8y1smmot5a-5clqxaane7w...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnote: adjust "SLRU cache sizes to be configured"

2024-05-25 Thread Bruce Momjian
doc PG 17 relnote: adjust "SLRU cache sizes to be configured" Add Álvaro Herrera as additional item author. Reported-by: Álvaro Herrera Discussion: https://postgr.es/m/202405231122.zew2gncy63fo@alvherre.pgsql Author: Álvaro Herrera Backpatch-through: master Branch -- master Details

pgsql: doc PG 17 relnotes: combine items

2024-05-25 Thread Bruce Momjian
doc PG 17 relnotes: combine items Reported-by: Andres Freund Discussion: https://postgr.es/m/20240524182329.gmzcd3a2zrvye...@awork3.anarazel.de Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/87331c68233425dd02048978e527dcf1ca505c6d

pgsql: doc PG 17 relnotes: fix pg_stat_reset_shared quoting

2024-05-22 Thread Bruce Momjian
doc PG 17 relnotes: fix pg_stat_reset_shared quoting Reported-by: torikoshia Discussion: https://postgr.es/m/8ab708436c369d47fcbb23a8ad775...@oss.nttdata.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: fix pg_stat_statements typo

2024-05-22 Thread Bruce Momjian
doc PG 17 relnotes: fix pg_stat_statements typo Reported-by: Masahiko Sawada Discussion: https://postgr.es/m/CAD21AoB_MR=S_Gh=oejr4ji0ggy+d8747o-5pycbmbhgomt...@mail.gmail.com Author: Masahiko Sawada Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: adjust SQL/JSON constructor func. authors

2024-05-22 Thread Bruce Momjian
doc PG 17 relnotes: adjust SQL/JSON constructor func. authors Reported-by: Amit Langote Discussion: https://postgr.es/m/CA+HiwqHA2_2V-UtdEEjX3wMUcO=pAwH2D=9p9crygvcnljk...@mail.gmail.com Author: Amit Langote Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: adjust builtin collation provider item

2024-05-22 Thread Bruce Momjian
doc PG 17 relnotes: adjust builtin collation provider item Reported-by: Jeff Davis Discussion: https://postgr.es/m/92e039f6fabc3567169e95e12b39a04c00f8503b.ca...@j-davis.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: add Heikki Linnakangas to vacuum item

2024-05-22 Thread Bruce Momjian
doc PG 17 relnotes: add Heikki Linnakangas to vacuum item Reported-by: Melanie Plageman Discussion: https://postgr.es/m/caakru_yyr5mxy-xucpr7dkkugcextsjry9ax8c-z7lka8dd...@mail.gmail.com Author: Melanie Plageman Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: adjust vacuum items

2024-05-20 Thread Bruce Momjian
doc PG 17 relnotes: adjust vacuum items Reported-by: John Naylor Discussion: https://postgr.es/m/CANWCAZbPEoFcSjedGsz4AV=_sbwun4sgjrukvcu-jzrqfc5...@mail.gmail.com Author: John Naylor Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: adjust vacuum item to use "or"

2024-05-19 Thread Bruce Momjian
doc PG 17 relnotes: adjust vacuum item to use "or" Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvrr1zq69keuwr5_bgo2iwnqhpzoozsz2g96knoxo0_...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: adjust "builtin" collation provider

2024-05-18 Thread Bruce Momjian
doc PG 17 relnotes: adjust "builtin" collation provider Reported-by: Daniel Verite Discussion: https://postgr.es/m/13447ff6-15fd-4137-8339-f4fddda7e...@manitou-mail.org Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: update to current

2024-05-18 Thread Bruce Momjian
doc PG 17 relnotes: update to current Reported-by: jian he Discussion: https://postgr.es/m/cacjufxe7fbwckfexdw86vtia2bv+locfnr-apf1cp2fjxeb...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: add incremental JSON parser item

2024-05-18 Thread Bruce Momjian
doc PG 17 relnotes: add incremental JSON parser item Reported-by: Andrew Dunstan Discussion: https://postgr.es/m/e48dbf1e-62c9-4dbb-8b42-bb9ed898a...@dunslane.net Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: improve JSON casting item

2024-05-18 Thread Bruce Momjian
doc PG 17 relnotes: improve JSON casting item Reported-by: jian he Discussion: https://postgr.es/m/cacjufxe0hy19f8oo-wb-+i4bkdamial_auv8qb69_8mwosc...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: adjust vacuum memory item

2024-05-18 Thread Bruce Momjian
doc PG 17 relnotes: adjust vacuum memory item Reported-by: David Rowley Discussion: https://postgr.es/m/caaphdvpznr+wrmx5wic9na60fzsbrueffmoecvubbjv483j...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: wording adjustments

2024-05-15 Thread Bruce Momjian
doc PG 17 relnotes: wording adjustments Reported-by: jian he Discussion: https://postgr.es/m/cacjufxhtjbqdmbc4ipgte_xd4amgonrm680ji5m5gca8+ye...@mail.gmail.com Co-authored-by: jian he Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: add item about vacuum storage/limits/WAL

2024-05-15 Thread Bruce Momjian
doc PG 17 relnotes: add item about vacuum storage/limits/WAL Reported-by: Alvaro Herrera Discussion: https://postgr.es/m/202405150838.sg5ddcexyyf4@alvherre.pgsql Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: add logical replication apply subtrans item

2024-05-14 Thread Bruce Momjian
doc PG 17 relnotes: add logical replication apply subtrans item Reported-by: Masahiko Sawada Discussion: https://postgr.es/m/CAD21AoD5jjB+M+BK5JTis8=W1g8KsS1961FyMqRpj=nbfxr...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: remove NOT NULL revert, add ALPN item

2024-05-14 Thread Bruce Momjian
doc PG 17 relnotes: remove NOT NULL revert, add ALPN item Make current as of 2024-05-14 Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/9bb47338d070105916157528304b79a0ad7baa81 Modified Files -- doc/src/sgml/release-17.sgml

pgsql: doc PG 17 relnotes: wording fix

2024-05-14 Thread Bruce Momjian
doc PG 17 relnotes: wording fix Reported-by: Pantelis Theodosiou Discussion: https://postgr.es/m/CAE3TBxxvkSGJGv7S0SMLSAe0khrQJBHsTca799r=vdjtn+b...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: wording fixes

2024-05-14 Thread Bruce Momjian
doc PG 17 relnotes: wording fixes Reported-by: Elena Indrupskaya Discussion: https://postgr.es/m/22110133-bca5-4a99-889c-aa0096423...@postgrespro.ru Author: Elena Indrupskaya Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: add two optimizer items

2024-05-14 Thread Bruce Momjian
doc PG 17 relnotes: add two optimizer items One is about subqueries becoming joins and the other is about optimizing LIMIT by improving startup cost. Reported-by: Andy Fan Discussion: https://postgr.es/m/87h6f4ncc6@163.com Reviewed-by: David Rowley Backpatch-through: master Branch

pgsql: doc PG 17 relnotes: add item about libpq large data transfers

2024-05-13 Thread Bruce Momjian
doc PG 17 relnotes: add item about libpq large data transfers Reported-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/cageczqtz5auqlel6dald2hu2fxs_losh4kedndj1fwthsb_...@mail.gmail.com Reviewed-by: Joe Conway Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: add psql connection control-C item

2024-05-13 Thread Bruce Momjian
doc PG 17 relnotes: add psql connection control-C item Reported-by: Jelte Fennema-Nio Discussion: https://postgr.es/m/cageczqtz5auqlel6dald2hu2fxs_losh4kedndj1fwthsb_...@mail.gmail.com Reviewed-by: Tom Lane Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: move FETCH_COUNT item, and clarify

2024-05-10 Thread Bruce Momjian
doc PG 17 relnotes: move FETCH_COUNT item, and clarify Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/31e8f4e619d9b5856fa2bd5713cb1e2e170a9c7d Modified Files -- doc/src/sgml/release-17.sgml | 22 +++--- 1 file

pgsql: doc PG 17 relnotes: add FETCH_COUNT item

2024-05-10 Thread Bruce Momjian
doc PG 17 relnotes: add FETCH_COUNT item Reported-by: Daniel Verite Discussion: https://postgr.es/m/82569de4-9b2a-4311-beb2-81d541849...@manitou-mail.org Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: fix author of LLVM item

2024-05-09 Thread Bruce Momjian
doc PG 17 relnotes: fix author of LLVM item Discussion: https://postgr.es/m/ca+hukg+yu4+yqscuquzdceetpdu+fjebxgv5fkp6xrtr7ek...@mail.gmail.com Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6a126d91cd042e708e101acafe23100ffb574251

pgsql: doc: clarify PERIOD and WITHOUT OVERLAPS in CREATE TABLE

2024-05-09 Thread Bruce Momjian
doc: clarify PERIOD and WITHOUT OVERLAPS in CREATE TABLE Discussion: https://postgr.es/m/04938501-fc8f-46f3-97a4-9a81a3f24...@illuminatedcomputing.com Author: Paul Jungwirth Backpatch-through: master Branch -- master Details ---

pgsql: doc PG 17 relnotes: Visual Studio clarification

2024-05-09 Thread Bruce Momjian
doc PG 17 relnotes: Visual Studio clarification Reported-by: Andrew Dunstan Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b538e692493be30132c0ee5984bc53f51920cded Modified Files -- doc/src/sgml/release-17.sgml | 4 ++-- 1

pgsql: doc PG 17 relnotes: Fixes from jian he

2024-05-09 Thread Bruce Momjian
doc PG 17 relnotes: Fixes from jian he Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d82ab9fc31aa62d94c26d7df98e65c6ceaadb01f Modified Files -- doc/src/sgml/release-17.sgml | 10 +- 1 file changed, 5 insertions(+), 5

pgsql: doc PG 17 relnotes: various fixes

2024-05-09 Thread Bruce Momjian
doc PG 17 relnotes: various fixes Fixes suggested by David Rowley, Bertrand Drouvot, Masahiko Sawada, Richard Guo, jian he, Dagfinn Ilmari Mannsåker Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/45ea5b0a2732849ef8bfb695808943d0d940abeb

pgsql: doc: first draft of Postgres 17 release notes

2024-05-08 Thread Bruce Momjian
doc: first draft of Postgres 17 release notes Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e305f71565e203e08e47d7094082188f5737317f Modified Files -- doc/src/sgml/release-17.sgml | 2825

Re: pgsql: Add allow_alter_system GUC.

2024-05-08 Thread Bruce Momjian
On Fri, Mar 29, 2024 at 08:47:18AM -0400, Robert Haas wrote: > Oh no! Jelte, I'm so sorry ... I spelled your name wrong in this > commit message. :-( > > Please accept my apologies. I have corrected his name in the release notes for this item. -- Bruce Momjian https:

pgsql: postgresql.conf: align variable comments, mostly new ones

2024-05-06 Thread Bruce Momjian
postgresql.conf: align variable comments, mostly new ones Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4712177a6c52b15918c9d6a4bdf8f00e79a18af3 Modified Files -- src/backend/utils/misc/postgresql.conf.sample | 24

Re: pgsql: Add allow_alter_system GUC.

2024-03-29 Thread Bruce Momjian
On Fri, Mar 29, 2024 at 08:47:18AM -0400, Robert Haas wrote: > Oh no! Jelte, I'm so sorry ... I spelled your name wrong in this > commit message. :-( > > Please accept my apologies. I have made a record of this so I will make sure it is accurate in the release notes. -- B

pgsql: doc: fix CREATE ROLE typo

2024-03-27 Thread Bruce Momjian
doc: fix CREATE ROLE typo This wording typo was added in PG 16. Reported-by: s.bai...@chorusintel.com Discussion: https://postgr.es/m/171150077554.7105.801523271545956...@wrigleys.postgresql.org Backpatch-through: 16 Branch -- master Details ---

pgsql: doc: fix CREATE ROLE typo

2024-03-27 Thread Bruce Momjian
doc: fix CREATE ROLE typo This wording typo was added in PG 16. Reported-by: s.bai...@chorusintel.com Discussion: https://postgr.es/m/171150077554.7105.801523271545956...@wrigleys.postgresql.org Backpatch-through: 16 Branch -- REL_16_STABLE Details ---

pgsql: C comment: mention no doc for negative start of substring(text)

2024-03-26 Thread Bruce Momjian
C comment: mention no doc for negative start of substring(text) Also add URL to hackers discussion. Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e648e77e25708874196326b6e4da30e7717156ab Modified Files --

pgsql: doc: add missing word "the"

2024-03-11 Thread Bruce Momjian
doc: add missing word "the" Reported-by: dough...@gmail.com Discussion: https://postgr.es/m/170993253510.640.5664117187431542...@wrigleys.postgresql.org Backpatch-through: 12 Branch -- REL_14_STABLE Details ---

pgsql: doc: add missing word "the"

2024-03-11 Thread Bruce Momjian
doc: add missing word "the" Reported-by: dough...@gmail.com Discussion: https://postgr.es/m/170993253510.640.5664117187431542...@wrigleys.postgresql.org Backpatch-through: 12 Branch -- master Details ---

pgsql: doc: add missing word "the"

2024-03-11 Thread Bruce Momjian
doc: add missing word "the" Reported-by: dough...@gmail.com Discussion: https://postgr.es/m/170993253510.640.5664117187431542...@wrigleys.postgresql.org Backpatch-through: 12 Branch -- REL_13_STABLE Details ---

pgsql: doc: add missing word "the"

2024-03-11 Thread Bruce Momjian
doc: add missing word "the" Reported-by: dough...@gmail.com Discussion: https://postgr.es/m/170993253510.640.5664117187431542...@wrigleys.postgresql.org Backpatch-through: 12 Branch -- REL_15_STABLE Details ---

pgsql: doc: add missing word "the"

2024-03-11 Thread Bruce Momjian
doc: add missing word "the" Reported-by: dough...@gmail.com Discussion: https://postgr.es/m/170993253510.640.5664117187431542...@wrigleys.postgresql.org Backpatch-through: 12 Branch -- REL_12_STABLE Details ---

pgsql: doc: add missing word "the"

2024-03-11 Thread Bruce Momjian
doc: add missing word "the" Reported-by: dough...@gmail.com Discussion: https://postgr.es/m/170993253510.640.5664117187431542...@wrigleys.postgresql.org Backpatch-through: 12 Branch -- REL_16_STABLE Details ---

pgsql: doc: improve role option documentation

2024-02-01 Thread Bruce Momjian
doc: improve role option documentation Role option management was changed in Postgres 16. This patch improves the docs around these changes, including CREATE ROLE's INHERIT option, inheritance handling, and grant's ability to change role options. Discussion:

pgsql: doc: improve role option documentation

2024-02-01 Thread Bruce Momjian
doc: improve role option documentation Role option management was changed in Postgres 16. This patch improves the docs around these changes, including CREATE ROLE's INHERIT option, inheritance handling, and grant's ability to change role options. Discussion:

pgsql: doc: clarify who owns the initdb-created cluster, by default

2024-01-10 Thread Bruce Momjian
doc: clarify who owns the initdb-created cluster, by default Discussion: https://postgr.es/m/zzotbsdkebg_h...@momjian.us Backpatch-through: 16 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/5b2da240e01ecaef8181b0feebaeb69e6fefdaa0 Modified Files --

pgsql: doc: clarify who owns the initdb-created cluster, by default

2024-01-10 Thread Bruce Momjian
doc: clarify who owns the initdb-created cluster, by default Discussion: https://postgr.es/m/zzotbsdkebg_h...@momjian.us Backpatch-through: 16 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/65ee2ed0d0da6dd45853b050b4d59634d64479bd Modified Files

pgsql: Update copyright for 2024

2024-01-03 Thread Bruce Momjian
Update copyright for 2024 Reported-by: Michael Paquier Discussion: https://postgr.es/m/zzktdpxbbmt3c...@paquier.xyz Backpatch-through: 12 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/79a2af3e7277122858da61eff8177d5fe487ce92 Modified Files

pgsql: Update copyright for 2024

2024-01-03 Thread Bruce Momjian
Update copyright for 2024 Reported-by: Michael Paquier Discussion: https://postgr.es/m/zzktdpxbbmt3c...@paquier.xyz Backpatch-through: 12 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/42afeae7b6db06c04ee5de7226b6b86e41b11da2 Modified Files

pgsql: Update copyright for 2024

2024-01-03 Thread Bruce Momjian
Update copyright for 2024 Reported-by: Michael Paquier Discussion: https://postgr.es/m/zzktdpxbbmt3c...@paquier.xyz Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/49fa18390cfbd03956a4820910777c3d6585d5a7 Modified Files

pgsql: Update copyright for 2024

2024-01-03 Thread Bruce Momjian
Update copyright for 2024 Reported-by: Michael Paquier Discussion: https://postgr.es/m/zzktdpxbbmt3c...@paquier.xyz Backpatch-through: 12 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/727cf6f6d31cf5a8cbe144207f22d0b76583f4d0 Modified Files

pgsql: Update copyright for 2024

2024-01-03 Thread Bruce Momjian
Update copyright for 2024 Reported-by: Michael Paquier Discussion: https://postgr.es/m/zzktdpxbbmt3c...@paquier.xyz Backpatch-through: 12 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/596eeb10972b30d3c3d6f8368b33378837bcd261 Modified Files

pgsql: doc: add ISO 8601 extended format example using to_char()

2023-12-26 Thread Bruce Momjian
doc: add ISO 8601 extended format example using to_char() Reported-by: juha.musto...@iki.fi Discussion: https://postgr.es/m/20170217160154.6101.52...@wrigleys.postgresql.org Co-authored-by: Erik Wienhold Backpatch-through: master Branch -- master Details ---

pgsql: doc: clarify handling of ON CONFLICT with triggers

2023-12-07 Thread Bruce Momjian
doc: clarify handling of ON CONFLICT with triggers The previous wording was confusing. Also move partitioning mention to a more logical location. Reported-by: n...@fairwindsoft.com Discussion: https://postgr.es/m/20170703200710.27956.64...@wrigleys.postgresql.org Backpatch-through: master

pgsql: doc, pg_upgrade: add vacuumdb w/ tips for generating quick stats

2023-12-07 Thread Bruce Momjian
doc, pg_upgrade: add vacuumdb w/ tips for generating quick stats Reported-by: Magnus Hagander Discussion: https://postgr.es/m/cabuevewgby-w7ektbjmy1rc+mmrl3fmrnx6yaukcr+7o9ps...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc: FOR UPDATE / KEY / SHARE / KEY SHARE takes an table alias

2023-12-07 Thread Bruce Momjian
doc: FOR UPDATE / KEY / SHARE / KEY SHARE takes an table alias Previously only a table name was documented for this SELECT clause. Reported-by: robert Discussion: https://postgr.es/m/152483686904.19805.3369061025704720...@wrigleys.postgresql.org Backpatch-through: master Branch --

pgsql: doc, intagg: fix one-to-many mention to many-to-many

2023-12-07 Thread Bruce Momjian
doc, intagg: fix one-to-many mention to many-to-many Reported-by: Christophe Courtois Discussion: https://postgr.es/m/aa7cfd73-0d8d-596a-b684-39faa479a...@dalibo.com Author: Christophe Courtois Backpatch-through: master Branch -- master Details ---

Re: pgsql: Doc: un-break PDF build.

2023-11-25 Thread Bruce Momjian
On Sat, Nov 25, 2023 at 02:18:43PM -0500, Bruce Momjian wrote: > I showed it previously in this thread: > > $ make postgres-A4.pdf 2>&1 | grep -v INFO > /usr/bin/xsltproc --nonet --path . --path . --stringparam pg.version > '17devel' --stringparam img.src.p

Re: pgsql: Doc: un-break PDF build.

2023-11-25 Thread Bruce Momjian
On Sat, Nov 25, 2023 at 02:14:11PM -0500, Andrew Dunstan wrote: > > On 2023-11-25 Sa 11:34, Bruce Momjian wrote: > > On Sat, Nov 25, 2023 at 11:26:16AM -0500, Tom Lane wrote: > > > Bruce Momjian writes: > > > > On Sat, Nov 25, 2023 at 10:50:10AM -0500, Tom Lan

Re: pgsql: Doc: un-break PDF build.

2023-11-25 Thread Bruce Momjian
On Sat, Nov 25, 2023 at 11:26:16AM -0500, Tom Lane wrote: > Bruce Momjian writes: > > On Sat, Nov 25, 2023 at 10:50:10AM -0500, Tom Lane wrote: > >> Yeah, for some reason it only shows up when building PDFs. > >> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=

Re: pgsql: Doc: un-break PDF build.

2023-11-25 Thread Bruce Momjian
On Sat, Nov 25, 2023 at 10:50:10AM -0500, Tom Lane wrote: > Bruce Momjian writes: > > Can someone tell me how you saw that warning in the build farm? I don't > > see it in with a make check or a build of the docs. > > Yeah, for some reason it only shows up when buil

Re: [COMMITTERS] pgsql: Move pg_test_fsync from contrib/ to src/bin/

2023-11-25 Thread Bruce Momjian
of a shape similar to the other files. Now > there is only that: > /* > *pg_test_fsync.c > *tests all supported fsync() methods > */ > An idea what this gives as a patch is attached. This patch is old but the header is still missing, so patch applied to master.

pgsql: C comment: add header to pg_test_fsync.c

2023-11-25 Thread Bruce Momjian
C comment: add header to pg_test_fsync.c Reported-by: Michael Paquier Discussion: https://postgr.es/m/cab7npqt1c9wruw4+esgf_-ru7erboc50a4r3ts1s-yt4oay...@mail.gmail.com Author: Michael Paquier Backpatch-through: master Branch -- master Details ---

pgsql: C comment: clarify that WAL files can be _recycled_ or removed

2023-11-25 Thread Bruce Momjian
C comment: clarify that WAL files can be _recycled_ or removed Reported-by: Michael Paquier Discussion: https://postgr.es/m/cab7npqsddf0heotqu3gsepgqx+9c+6kjld3r6anyh7kkfdd...@mail.gmail.com Author: Michael Paquier Backpatch-through: master Branch -- master Details ---

Re: pgsql: Doc: un-break PDF build.

2023-11-25 Thread Bruce Momjian
On Fri, Nov 24, 2023 at 08:16:12PM -0500, Bruce Momjian wrote: > > Thanks, I missed that issue. Can someone tell me how you saw that warning in the build farm? I don't see it in with a make check or a build of the docs. Attached is the patch that

pgsql: Use SECS_PER_HOUR macro in tzparser.c, instead of constants

2023-11-24 Thread Bruce Momjian
Use SECS_PER_HOUR macro in tzparser.c, instead of constants Reported-by: CharSyam Discussion: https://postgr.es/m/camrlse5j_awfobdmrsvk14obksy+-2cjznnh_fciira7kwo...@mail.gmail.com Author: CharSyam Backpatch-through: master Branch -- master Details ---

pgsql: doc: gin_page_opaque_info() must be a _compressed_ GIN page

2023-11-24 Thread Bruce Momjian
doc: gin_page_opaque_info() must be a _compressed_ GIN page Reported-by: Jeff Janes Discussion: https://postgr.es/m/CAMkU=1xvzqxtaiynm2pwj6snmtph3u3ammbwss7mvashs2o...@mail.gmail.com Author: Jeff Janes Backpatch-through: master Branch -- master Details ---

Re: pgsql: Doc: un-break PDF build.

2023-11-24 Thread Bruce Momjian
er buildfarm. > > Branch > -- > master > > Details > --- > https://git.postgresql.org/pg/commitdiff/798394c6ccdada517c3508047a865d9994bfe25f > > Modified Files > -- > doc/src/sgml/gin.sgml | 2 +- > 1 file changed, 1 insertion(+), 1

pgsql: doc: improve ALTER TABLE "offical constraint" wording

2023-11-24 Thread Bruce Momjian
doc: improve ALTER TABLE "offical constraint" wording Reported-by: Josh Kupershmidt Discussion: https://postgr.es/m/CAK3UJRF=KY_nx_TRQq+t6jOrtS2rry79ktkzPiMDhFx_K=d...@mail.gmail.com Author: Josh Kupershmidt Backpatch-through: master Branch -- master Details ---

pgsql: modify segno. for pg_walfile_name() and pg_walfile_name_offset()

2023-11-24 Thread Bruce Momjian
modify segno. for pg_walfile_name() and pg_walfile_name_offset() Previously these functions returned the previous segment number if the LSN was on a segment boundary. We now always return the current segment number for an LSN. Docs updated to reflect this change. Regression tests added, author

pgsql: doc: remove documentation for deprecated @@@ operator

2023-11-24 Thread Bruce Momjian
doc: remove documentation for deprecated @@@ operator Reported-by: Kyotaro HORIGUCHI Discussion: https://postgr.es/m/caf4au4wmuszrvhr+yspvabrfb_1d1fnrpy9trako2debi4c...@mail.gmail.com Co-authored-by: Oleg Bartunov Backpatch-through: master Branch -- master Details ---

pgsql: doc: mention vacuum's removal of commit timestamp information

2023-11-24 Thread Bruce Momjian
doc: mention vacuum's removal of commit timestamp information Reported-by: Kyotaro HORIGUCHI Discussion: https://postgr.es/m/20180622.172132.230342845.horiguchi.kyot...@lab.ntt.co.jp Co-authored-by: Kyotaro HORIGUCHI Backpatch-through: 16 Branch -- REL_16_STABLE Details ---

pgsql: doc: mention vacuum's removal of commit timestamp information

2023-11-24 Thread Bruce Momjian
doc: mention vacuum's removal of commit timestamp information Reported-by: Kyotaro HORIGUCHI Discussion: https://postgr.es/m/20180622.172132.230342845.horiguchi.kyot...@lab.ntt.co.jp Co-authored-by: Kyotaro HORIGUCHI Backpatch-through: 16 Branch -- master Details ---

pgsql: doc: add docs for age(xid) and mxid_age(xid)

2023-11-24 Thread Bruce Momjian
doc: add docs for age(xid) and mxid_age(xid) Reported-by: David Rowley Discussion: https://postgr.es/m/CAKJS1f_OQpz7rpe-KJmskVxbU06buiXbfonxG3JLB+nGCJ5E=g...@mail.gmail.com Backpatch-through: 16 Branch -- master Details ---

pgsql: doc: add docs for age(xid) and mxid_age(xid)

2023-11-24 Thread Bruce Momjian
doc: add docs for age(xid) and mxid_age(xid) Reported-by: David Rowley Discussion: https://postgr.es/m/CAKJS1f_OQpz7rpe-KJmskVxbU06buiXbfonxG3JLB+nGCJ5E=g...@mail.gmail.com Backpatch-through: 16 Branch -- REL_16_STABLE Details ---

pgsql: C comment: fix typos with unnecessary apostrophes

2023-11-22 Thread Bruce Momjian
C comment: fix typos with unnecessary apostrophes Reported-by: Vinayak Pokale Discussion: https://postgr.es/m/CAEySZvh7gPTOqMhuKOBXEt=qf_1bcvfqb4maj4yatpjhxgx...@mail.gmail.com Author: Vinayak Pokale Backpatch-through: master Branch -- master Details ---

pgsql: doc: remove double-negative in REFRESH MATERIALIZED ... CONCURR

2023-11-22 Thread Bruce Momjian
doc: remove double-negative in REFRESH MATERIALIZED ... CONCURR Reported-by: a...@robillo.net Discussion: https://postgr.es/m/20170208152743.1411.6...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details ---

pgsql: doc: FreeBSD uses camcontrol identify, not atacontrol, for cache

2023-11-21 Thread Bruce Momjian
doc: FreeBSD uses camcontrol identify, not atacontrol, for cache This is for IDE drive cache control, same as SCSI (already documented properly). Reported-by: John Ekins Discussion: https://postgr.es/m/20170808224017.8424.69...@wrigleys.postgresql.org Author: John Ekins Backpatch-through: 12

pgsql: doc: FreeBSD uses camcontrol identify, not atacontrol, for cache

2023-11-21 Thread Bruce Momjian
doc: FreeBSD uses camcontrol identify, not atacontrol, for cache This is for IDE drive cache control, same as SCSI (already documented properly). Reported-by: John Ekins Discussion: https://postgr.es/m/20170808224017.8424.69...@wrigleys.postgresql.org Author: John Ekins Backpatch-through: 12

pgsql: doc: FreeBSD uses camcontrol identify, not atacontrol, for cache

2023-11-21 Thread Bruce Momjian
doc: FreeBSD uses camcontrol identify, not atacontrol, for cache This is for IDE drive cache control, same as SCSI (already documented properly). Reported-by: John Ekins Discussion: https://postgr.es/m/20170808224017.8424.69...@wrigleys.postgresql.org Author: John Ekins Backpatch-through: 12

pgsql: doc: FreeBSD uses camcontrol identify, not atacontrol, for cache

2023-11-21 Thread Bruce Momjian
doc: FreeBSD uses camcontrol identify, not atacontrol, for cache This is for IDE drive cache control, same as SCSI (already documented properly). Reported-by: John Ekins Discussion: https://postgr.es/m/20170808224017.8424.69...@wrigleys.postgresql.org Author: John Ekins Backpatch-through: 12

pgsql: doc: FreeBSD uses camcontrol identify, not atacontrol, for cache

2023-11-21 Thread Bruce Momjian
doc: FreeBSD uses camcontrol identify, not atacontrol, for cache This is for IDE drive cache control, same as SCSI (already documented properly). Reported-by: John Ekins Discussion: https://postgr.es/m/20170808224017.8424.69...@wrigleys.postgresql.org Author: John Ekins Backpatch-through: 12

pgsql: doc: FreeBSD uses camcontrol identify, not atacontrol, for cache

2023-11-21 Thread Bruce Momjian
doc: FreeBSD uses camcontrol identify, not atacontrol, for cache This is for IDE drive cache control, same as SCSI (already documented properly). Reported-by: John Ekins Discussion: https://postgr.es/m/20170808224017.8424.69...@wrigleys.postgresql.org Author: John Ekins Backpatch-through: 12

pgsql: doc: vacuum_cost_limit controls when vacuum_cost_delay happens

2023-11-21 Thread Bruce Momjian
doc: vacuum_cost_limit controls when vacuum_cost_delay happens Mention this relationship. Reported-by: Martín Marqués Discussion: https://postgr.es/m/cabeg9ltsavp4waknguyo-haiiowcb8xejqvddfhx_nfi5sj...@mail.gmail.com Author: Martín Marqués Backpatch-through: master Branch -- master

pgsql: doc: update query section to show LIMIT/OFFSET like SELECT

2023-11-17 Thread Bruce Momjian
doc: update query section to show LIMIT/OFFSET like SELECT The parameter names were slightly better in SELECT, so make them match. Reported-by: Euler Taveira Discussion: https://postgr.es/m/cahe3wgh-eyuablg1vs3qthii1tgws31h-fyegrdda7otous...@mail.gmail.com Backpatch-through: master Branch

pgsql: doc: clarify handling of ts_headline() operators & extra words

2023-11-13 Thread Bruce Momjian
doc: clarify handling of ts_headline() operators & extra words Reported-by: Ngigi Waithaka & Alex Malek Bug: 15172 Discussion: https://postgr.es/m/152461454026.19805.6310947081647212...@wrigleys.postgresql.org Backpatch-through: 16 Branch -- REL_16_STABLE Details ---

pgsql: doc: clarify handling of ts_headline() operators & extra words

2023-11-13 Thread Bruce Momjian
doc: clarify handling of ts_headline() operators & extra words Reported-by: Ngigi Waithaka & Alex Malek Bug: 15172 Discussion: https://postgr.es/m/152461454026.19805.6310947081647212...@wrigleys.postgresql.org Backpatch-through: 16 Branch -- master Details ---

pgsql: psql: improve description consistency of \dTS data types

2023-11-13 Thread Bruce Momjian
psql: improve description consistency of \dTS data types This was done particularly for geometric data types. Reported-by: Christoph Berg Discussion: https://postgr.es/m/ygi8leuk0wvmn...@msg.df7cb.de Co-authored-by: Kyotaro Horiguchi Backpatch-through: master Branch -- master Details

pgsql: doc: clarify handling of range upper/lower/upper_inf/lower_inf()

2023-11-13 Thread Bruce Momjian
doc: clarify handling of range upper/lower/upper_inf/lower_inf() Clarify handling of infinite range bounds. Reported-by: jani.rahk...@iki.fi Discussion: https://postgr.es/m/160508672127.25505.8356390205508789...@wrigleys.postgresql.org Co-authored-by: Laurenz Albe Backpatch-through: 16

pgsql: doc: clarify handling of range upper/lower/upper_inf/lower_inf()

2023-11-13 Thread Bruce Momjian
doc: clarify handling of range upper/lower/upper_inf/lower_inf() Clarify handling of infinite range bounds. Reported-by: jani.rahk...@iki.fi Discussion: https://postgr.es/m/160508672127.25505.8356390205508789...@wrigleys.postgresql.org Co-authored-by: Laurenz Albe Backpatch-through: 16

pgsql: doc: move ROW IS NULL examples to a different chapter

2023-11-13 Thread Bruce Momjian
doc: move ROW IS NULL examples to a different chapter Also add examples. Reported-by: Wolfgang Walther Discussion: https://postgr.es/m/21ff8e9c-627a-f949-fb00-a41b9ddcc...@technowledgy.de Backpatch-through: master Branch -- master Details ---

pgsql: doc: clarify that pg_global can _only_ be used for system tabs.

2023-11-13 Thread Bruce Momjian
doc: clarify that pg_global can _only_ be used for system tabs. Reported-by: zhoushulin1...@gmail.com Discussion: https://postgr.es/m/160499688847.25495.8682880307938679...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details ---

pgsql: Adjust file_fdw regression tests for acc95f29ef FREEZE commit

2023-11-13 Thread Bruce Momjian
Adjust file_fdw regression tests for acc95f29ef FREEZE commit Reported-by: Tom Lane Discussion: https://postgr.es/m/2161529.1699899...@sss.pgh.pa.us Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e61a82c949353d9684d037a9a404fbb26b651535

Re: pgsql: doc: restructure ALTER DEFAULT PRIVILEGES

2023-11-13 Thread Bruce Momjian
On Mon, Nov 13, 2023 at 07:28:01PM +, Bruce Momjian wrote: > doc: restructure ALTER DEFAULT PRIVILEGES > > Clarify that default privileges are not inherited and reorder > paragraphs. This is a follow up to a recent ALTER DEFAULT PRIVILEGES > doc patch. > > Repo

pgsql: doc: restructure ALTER DEFAULT PRIVILEGES

2023-11-13 Thread Bruce Momjian
doc: restructure ALTER DEFAULT PRIVILEGES Clarify that default privileges are not inherited and reorder paragraphs. This is a follow up to a recent ALTER DEFAULT PRIVILEGES doc patch. Reported-by: Sanjay Minni Diagnosed-by: AMpxBo=M35hcH1g4Vg=krj0-77fojcvdrdivf5ksoadog-l...@mail.gmail.com

pgsql: doc: restructure ALTER DEFAULT PRIVILEGES

2023-11-13 Thread Bruce Momjian
doc: restructure ALTER DEFAULT PRIVILEGES Clarify that default privileges are not inherited and reorder paragraphs. This is a follow up to a recent ALTER DEFAULT PRIVILEGES doc patch. Reported-by: Sanjay Minni Diagnosed-by: AMpxBo=M35hcH1g4Vg=krj0-77fojcvdrdivf5ksoadog-l...@mail.gmail.com

pgsql: doc: correct description of libpq's PQsetnonblocking() mode

2023-11-13 Thread Bruce Momjian
doc: correct description of libpq's PQsetnonblocking() mode Reported-by: Yugo NAGATA Discussion: https://postgr.es/m/20210713115949.702986955f8ccf23fa810...@sraoss.co.jp Backpatch-through: 12-16, master already done Branch -- REL_13_STABLE Details ---

  1   2   3   4   5   6   7   8   9   10   >