Re: pgsql: Update time zone data files to tzdata release 2024b.

2024-11-01 Thread Andrew Dunstan
On Wed, Oct 30, 2024 at 7:20 PM Tom Lane wrote: > I wrote: > > So the problem is precisely that *our* interpretation of EST5EDT > > changed when we adopted tzdata 2024b, and that is affecting how > > we dump these old timestamps. Or at least, that seems like what > > should be happening, but the

pgsql: doc: clarify text around MVCC example query

2024-11-01 Thread Bruce Momjian
doc: clarify text around MVCC example query Reported-by: marlene.brandstaetter@cargonet.software Discussion: https://postgr.es/m/167765529052.987840.12345375075704447...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/comm

pgsql: doc: remove useless MERGE example

2024-11-01 Thread Bruce Momjian
doc: remove useless MERGE example Reported-by: dwayne.tow...@gmail.com Discussion: https://postgr.es/m/167699245721.1902146.6479762301617101...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4a9effe45ee96f7105ba

pgsql: doc: improve tablespace example query and link to helper funcs.

2024-11-01 Thread Bruce Momjian
doc: improve tablespace example query and link to helper funcs. Reported-by: Agustín Discussion: https://postgr.es/m/172609721070.1128084.6724666076293146...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e1a76d

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: doc: fix ALTER DOMAIN domain_constraint to spell out options

2024-11-01 Thread Bruce Momjian
doc: fix ALTER DOMAIN domain_constraint to spell out options It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, while ALTER DOMAIN does not. Reported-by: elione...@yahoo.com Discussion: https://postgr.es/m/172225092461.915373.6103973717483380...@wrigleys.postgresql.org Backpatc

pgsql: Update contrib/sepgsql regression tests for commit 89e51abcb.

2024-11-01 Thread Tom Lane
Update contrib/sepgsql regression tests for commit 89e51abcb. Oversight revealed by buildfarm. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/cf590c568d0535785d594f79dcdaafdfeb46ac2f Modified Files -- contrib/sepgsql/expected/ddl.out | 4 1 file ch

pgsql: doc: explain how the home directory is found on Unix-like syst.

2024-11-01 Thread Bruce Momjian
doc: explain how the home directory is found on Unix-like syst. Done for libpq, postgres-fdw, and psql. Reported-by: m...@msys.ch Discussion: https://postgr.es/m/CAKFQuwZ-T-zsVM7gApS9-XU9vGxC7Oa-UyRQPVcJFagNU=a...@mail.gmail.com Backpatch-through: master Branch -- master Details ---

pgsql: doc: Add link to listen_addresses as cause of connection failure

2024-11-01 Thread Bruce Momjian
doc: Add link to listen_addresses as cause of connection failure Reported-by: k.man@gmail.com Discussion: https://postgr.es/m/171494070007.703.17021965362263796...@wrigleys.postgresql.org Backpatch-through: master Branch -- master Details --- https://git.postgresql.org/pg/commitdi

pgsql: doc: improve build for non-Latin1 characters

2024-11-01 Thread Bruce Momjian
doc: improve build for non-Latin1 characters Add README.non-ASCII to explain non-ASCII doc behavior; some text moved from release.sgml. Change UTF8 SGML characters to use HTML entities. Remove unnecessary UTF8 spaces. Add SVG file check for check-nbsp target. Add dummy 'pdf' Makefile target.

pgsql: Clarify nbtree array preprocessing comment.

2024-11-01 Thread Peter Geoghegan
Clarify nbtree array preprocessing comment. Oversight in commit 5bf748b8. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fc7ddededb9ee466d20581b966e01a3566b9559f Modified Files -- src/backend/access/nbtree/nbtutils.c | 5 +++-- 1 file changed, 3 inserti

pgsql: Rename two functions that wake up other processes

2024-11-01 Thread Heikki Linnakangas
Rename two functions that wake up other processes Instead of talking about setting latches, which is a pretty low-level mechanism, emphasize that they wake up other processes. This is in preparation for replacing Latches with a new abstraction. That's still work in progress, but this seems a litt

pgsql: Use ProcNumbers instead of direct Latch pointers to address othe

2024-11-01 Thread Heikki Linnakangas
Use ProcNumbers instead of direct Latch pointers to address other procs This is in preparation for replacing Latches with a new abstraction. That's still work in progress, but this seems a little tidier anyway, so let's get this refactoring out of the way already. Discussion: https://www.postgre

pgsql: Remove use of pg_memory_is_all_zeros() in bufpage.c

2024-11-01 Thread Michael Paquier
Remove use of pg_memory_is_all_zeros() in bufpage.c After a closer lookup, this makes the all-zero check of the page more expensive, so let's remove the new function call in bufpage.c. The maths of the check were also incorrect, checking that the page was full of zeros only for the first 1kB. Th