Re: pgsql: Add isolation tests for snapshot behavior in ri_triggers.c

2022-04-10 Thread Amit Langote
Hi Alvaro, On Fri, Apr 8, 2022 at 3:32 AM Alvaro Herrera wrote: > Add isolation tests for snapshot behavior in ri_triggers.c > > They are to check the behavior of RI_FKey_check() and > ri_Check_Pk_Match(). A test case whereby RI_FKey_check() queries a > partitioned PK table under REPEATABLE READ

pgsql: Put new command-line options into alphabetical order in help out

2022-04-10 Thread Peter Eisentraut
Put new command-line options into alphabetical order in help output Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0c65177a21a9e23490bee0e50ba61eeb287f7183 Modified Files -- src/bin/pg_basebackup/pg_basebackup.c | 4 ++-- src/bin/pg_rewind/pg_rewind.c

pgsql: doc: Clarify behavior of query planner locking with REINDEX

2022-04-10 Thread Michael Paquier
doc: Clarify behavior of query planner locking with REINDEX The documentation of REINDEX has never mentioned that the query planner may take an ACCESS SHARE lock on the indexes depending on the query used. This adds also a note about prepared queries not impacted when they do not use the index(es

pgsql: Doc: fix typos in documentation

2022-04-10 Thread Daniel Gustafsson
Doc: fix typos in documentation Commits 39969e2a1e4 and 5c279a6d350 accidentally included a typo each in the user facing documentation. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/cd959b1b0662c9d57540b31961680c38037ffcd6 Modified Files -- doc/src/sg

pgsql: Doc: reformat descriptions of pgbench output formats.

2022-04-10 Thread Tom Lane
Doc: reformat descriptions of pgbench output formats. This is mostly driven by trying to get rid of line-too-wide warnings in PDF output; but I think converting to a makes it more readable anyway. Discussion: https://postgr.es/m/4183048.1649536...@sss.pgh.pa.us Branch -- master Details ---

pgsql: Add timestamp and elapsed time decorations to TAP test logs

2022-04-10 Thread Andrew Dunstan
Add timestamp and elapsed time decorations to TAP test logs These apply to traces from Test::More functions such as ok(), is(), diag() and note(). Output from other sources (e.g. external programs such a initdb) is not affected. The elapsed time is the time since the last such trace (or the beginn

pgsql: Fix pgperlsyncheck following SSL TAP test refactoring

2022-04-10 Thread Andrew Dunstan
Fix pgperlsyncheck following SSL TAP test refactoring Commit 4a7e964fc6 made pgperlsyncheck fail, but apparently nobody noticed, although the buildfarm module that does more or less the same thing was modified. So fix the in-core test. I will look at unifying the two sets of tests so we avoid a fu