pgsql: Documentation update for Standard Collations.

2024-03-02 Thread Jeff Davis
Documentation update for Standard Collations.

Correct out-of-date text that said the "default" collation is always
based on LC_COLLATE and LC_CTYPE.

Also reformat into a list to make it easier to understand and compare
the available collations, and briefly document the stability
characteristics of each one.

Discussion: 
https://postgr.es/m/4a69d067374d2f6bfb66f5bfb2ab9a020493d49f.ca...@j-davis.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/875e46a0a246e416b12a9debe084ede9d02f1b5d

Modified Files
--
doc/src/sgml/charset.sgml | 72 +--
1 file changed, 45 insertions(+), 27 deletions(-)



pgsql: Fix overflow in Windows replacement pg_pread/pg_pwrite.

2024-03-02 Thread Thomas Munro
Fix overflow in Windows replacement pg_pread/pg_pwrite.

When calling the Windows file I/O APIs there is an implicit conversion
from size_t to DWORD, which could overflow.  Clamp the size at 1GB to
avoid that.

Not a really a live bug as we don't expect anything in PostgreSQL to
call with such large values.

Reviewed-by: Peter Eisentraut 
Discussion: https://postgr.es/m/1672202.1703441340%40sss.pgh.pa.us

Branch
--
master

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

Modified Files
--
src/port/win32pread.c  | 3 +++
src/port/win32pwrite.c | 3 +++
2 files changed, 6 insertions(+)