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
---
https://git.postgresql.org/pg/commitdiff/79588d3c8d08b8653dfc523d6ae5168652c6ff8a

Modified Files
--
src/backend/utils/misc/tzparser.c | 7 ---
1 file changed, 4 insertions(+), 3 deletions(-)



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
---
https://git.postgresql.org/pg/commitdiff/9890a855ae82d2185c6dcd98f0071a0c889cacc3

Modified Files
--
doc/src/sgml/pageinspect.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



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

2023-11-24 Thread Bruce Momjian


Thanks, I missed that issue.

---

On Sat, Nov 25, 2023 at 01:03:11AM +, Tom Lane wrote:
> Doc: un-break PDF build.
> 
> Oversight in 5c4c7efad: gotta adjust the cell height for removal of
> an entry.  Per 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 deletion(-)
> 


-- 
  Bruce Momjian  https://momjian.us
  EDB  https://enterprisedb.com

  Only you can decide what is important to you.




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
---
https://git.postgresql.org/pg/commitdiff/712dc2338b23196edd94619f43f24d23139cc0a9

Modified Files
--
doc/src/sgml/ref/alter_table.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: Doc: un-break PDF build.

2023-11-24 Thread Tom Lane
Doc: un-break PDF build.

Oversight in 5c4c7efad: gotta adjust the cell height for removal of
an entry.  Per 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 deletion(-)



pgsql: gitignore generated file targets-meson.sgml.

2023-11-24 Thread Tom Lane
gitignore generated file targets-meson.sgml.

Oversight in 07cb29737.

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/1a0796b9279b1cbbb3d1ede9b06d930d49e57a6c

Modified Files
--
doc/src/sgml/.gitignore | 1 +
1 file changed, 1 insertion(+)



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
Andres Freund.

Also mentioned in thread 
https://postgr.es/m/flat/20220204225057.GA1535307%40nathanxps13#d964275c9540d8395e138efc0a75f7e8

BACKWARD INCOMPATIBILITY

Reported-by: Kyotaro Horiguchi

Discussion: 
https://postgr.es/m/20190726.172120.101752680.horikyota@gmail.com

Co-authored-by: Kyotaro Horiguchi

Backpatch-through: master

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/344afc77690b4cef2605420d67c1d1ceb28760cc

Modified Files
--
doc/src/sgml/func.sgml   |  5 -
src/backend/access/transam/xlogfuncs.c   |  8 ++--
src/test/regress/expected/misc_functions.out | 30 +++-
src/test/regress/sql/misc_functions.sql  | 15 +-
4 files changed, 45 insertions(+), 13 deletions(-)



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
---
https://git.postgresql.org/pg/commitdiff/5c4c7efaddd4ddd70176dadf3097efcacf811adf

Modified Files
--
doc/src/sgml/func.sgml | 18 --
doc/src/sgml/gin.sgml  |  3 ---
2 files changed, 21 deletions(-)



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
---
https://git.postgresql.org/pg/commitdiff/c136eb02981566d56e950f12ab7ee4a6ea51d698

Modified Files
--
doc/src/sgml/func.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



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
---
https://git.postgresql.org/pg/commitdiff/49d7e713d93033f6b8c8b37e8bb2a8362c2dec52

Modified Files
--
doc/src/sgml/func.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



pgsql: Fix whitespace.

2023-11-24 Thread Thomas Munro
Fix whitespace.

Use tabs instead of spaces for new paragraph, like existing paragraphs.

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/6631363a5992a81d7bbcecaba68886564ad701ba

Modified Files
--
src/port/pqsignal.c | 18 +-
1 file changed, 9 insertions(+), 9 deletions(-)



pgsql: Improve comments about pqsignal().

2023-11-24 Thread Thomas Munro
Improve comments about pqsignal().

Explain where pqsignal() came from, what problem it originally solved
without assuming the reader is familiar with historical Unixen, why we
still need it, what it does for us now, and the key differences in
frontend code on Windows.

Reviewed-by: Heikki Linnakangas 
Discussion: 
https://postgr.es/m/CA%2BhUKG%2BRst1h3uo%2BXRgdRVnWHBa4mmj5gFbmCzZr73s-Fh_5JA%40mail.gmail.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/262454be9a62d69d7523c0c88c7d07d5971a0fa0

Modified Files
--
src/port/pqsignal.c | 34 ++
1 file changed, 26 insertions(+), 8 deletions(-)



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
---
https://git.postgresql.org/pg/commitdiff/48b5aa31437a161356fb8ec820b81b7b67cf04c2

Modified Files
--
doc/src/sgml/func.sgml | 28 
1 file changed, 28 insertions(+)



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
---
https://git.postgresql.org/pg/commitdiff/7471230cc697fec3dc3c4094aa81469c02fa53c6

Modified Files
--
doc/src/sgml/func.sgml | 28 
1 file changed, 28 insertions(+)