pgsql: pg_ctl: Disable autoruns for cmd.exe on Windows

2024-01-09 Thread Michael Paquier
pg_ctl: Disable autoruns for cmd.exe on Windows On Windows, cmd.exe is used to launch the postmaster process to ease its redirection setup. However, cmd.exe may execute other programs at startup due to autorun configurations, which could influence the postmaster startup. This patch adds /D flag

pgsql: Document WAL summarization information functions.

2024-01-09 Thread Robert Haas
Document WAL summarization information functions. Commit 174c480508ac25568561443e6d4a82d5c1103487 added two new information functions but failed to document them anywhere. Discussion: http://postgr.es/m/CA+Tgmobvqqj-DW9F7uUzT-cQqs6wcVb-Xhs=w=hzjnxse-k...@mail.gmail.com Branch -- master Det

pgsql: Fix documentation for wal_summary_keep_time.

2024-01-09 Thread Nathan Bossart
Fix documentation for wal_summary_keep_time. The documentation for this parameter lists its type as boolean, but it is actually an integer. Furthermore, there is no mention of how the value is interpreted when specified without units. This commit fixes these oversights in commit 174c480508. Co-

pgsql: Cross-check lists of predefined LWLocks.

2024-01-09 Thread Nathan Bossart
Cross-check lists of predefined LWLocks. Both lwlocknames.txt and wait_event_names.txt contain a list of all the predefined LWLocks, i.e., those with predefined positions within MainLWLockArray. It is easy to miss one or the other, especially since the list in wait_event_names.txt omits the "Lock

pgsql: Add new function, PQchangePassword(), to libpq

2024-01-09 Thread Joe Conway
Add new function, PQchangePassword(), to libpq Essentially this moves the non-interactive part of psql's "\password" command into an exported client function. The password is not sent to the server in cleartext because it is "encrypted" (in the case of scram and md5 it is actually hashed, but we h

pgsql: Doc: fix character_sets view.

2024-01-09 Thread Tatsuo Ishii
Doc: fix character_sets view. The note regarding character encoding form in "The Information Schema" said that LATIN1 character repertoires only use one encoding form LATIN1. This is not correct because LATIN1 has another encoding form ISO-2022-JP-2. To fix this, replace LATIN1 with LATIN2, which

pgsql: Doc: fix character_sets view.

2024-01-09 Thread Tatsuo Ishii
Doc: fix character_sets view. The note regarding character encoding form in "The Information Schema" said that LATIN1 character repertoires only use one encoding form LATIN1. This is not correct because LATIN1 has another encoding form ISO-2022-JP-2. To fix this, replace LATIN1 with LATIN2, which

pgsql: Doc: fix character_sets view.

2024-01-09 Thread Tatsuo Ishii
Doc: fix character_sets view. The note regarding character encoding form in "The Information Schema" said that LATIN1 character repertoires only use one encoding form LATIN1. This is not correct because LATIN1 has another encoding form ISO-2022-JP-2. To fix this, replace LATIN1 with LATIN2, which

pgsql: Doc: fix character_sets view.

2024-01-09 Thread Tatsuo Ishii
Doc: fix character_sets view. The note regarding character encoding form in "The Information Schema" said that LATIN1 character repertoires only use one encoding form LATIN1. This is not correct because LATIN1 has another encoding form ISO-2022-JP-2. To fix this, replace LATIN1 with LATIN2, which

pgsql: Doc: fix character_sets view.

2024-01-09 Thread Tatsuo Ishii
Doc: fix character_sets view. The note regarding character encoding form in "The Information Schema" said that LATIN1 character repertoires only use one encoding form LATIN1. This is not correct because LATIN1 has another encoding form ISO-2022-JP-2. To fix this, replace LATIN1 with LATIN2, which

pgsql: Doc: fix character_sets view.

2024-01-09 Thread Tatsuo Ishii
Doc: fix character_sets view. The note regarding character encoding form in "The Information Schema" said that LATIN1 character repertoires only use one encoding form LATIN1. This is not correct because LATIN1 has another encoding form ISO-2022-JP-2. To fix this, replace LATIN1 with LATIN2, which

pgsql: An addition to 8c441c08279

2024-01-09 Thread Alexander Korotkov
An addition to 8c441c08279 Given that now SJE doesn't work with result relation, turn a code dealing with that into an assert that it shouldn't happen. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/028b15405b4113e1b0f492bf9908d001a5983a77 Modified Files -

pgsql: Forbid SJE with result relation

2024-01-09 Thread Alexander Korotkov
Forbid SJE with result relation The target relation for INSERT/UPDATE/DELETE/MERGE has a different behavior than other relations in EvalPlanQual() and RETURNING clause. This is why we forbid target relation to be either source or target relation in SJE. It's not clear if we could ever support thi