pgsql: Simplify one use of ScanKey in pg_subscription.c

2021-05-11 Thread Michael Paquier
Simplify one use of ScanKey in pg_subscription.c The section of the code in charge of returning all the relations associated to a subscription only need one ScanKey, but allocated two of them. This code was introduced as a copy-paste from a different area on the same file by 7c4f524, making the

pgsql: Refactor some error messages for easier translation

2021-05-11 Thread Peter Eisentraut
Refactor some error messages for easier translation Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ec6e70c79fffe9292402ee602d3742a8c7d31bd2 Modified Files -- src/backend/access/common/toast_compression.c | 2 +- src/backend/parser/parse_coerce.c

Re: pgsql: Add support for LZ4 build in MSVC scripts

2021-05-11 Thread Michael Paquier
On Tue, May 11, 2021 at 08:49:35PM -0400, Andrew Dunstan wrote: > I don't think there's anything to do here. On Msys2 I think you can just > do 'pacman -S mingw64/mingw-w64-x86_64-lz4' and configure as normal. Good to know. Thanks! -- Michael signature.asc Description: PGP signature

pgsql: Fix EXPLAIN ANALYZE for async-capable nodes.

2021-05-11 Thread Etsuro Fujita
Fix EXPLAIN ANALYZE for async-capable nodes. EXPLAIN ANALYZE for an async-capable ForeignScan node associated with postgres_fdw is done just by using instrumentation for ExecProcNode() called from the node's callbacks, causing the following problems: 1) If the remote table to scan is empty, the

pgsql: Reduce runtime of privileges.sql test under CLOBBER_CACHE_ALWAYS

2021-05-11 Thread Tom Lane
Reduce runtime of privileges.sql test under CLOBBER_CACHE_ALWAYS. Several queries in the privileges regression test cause the planner to apply the plpgsql function "leak()" to every element of the histogram for atest12.b. Since commit 0c882e52a increased the size of that histogram to 1

pgsql: Reduce runtime of privileges.sql test under CLOBBER_CACHE_ALWAYS

2021-05-11 Thread Tom Lane
Reduce runtime of privileges.sql test under CLOBBER_CACHE_ALWAYS. Several queries in the privileges regression test cause the planner to apply the plpgsql function "leak()" to every element of the histogram for atest12.b. Since commit 0c882e52a increased the size of that histogram to 1

pgsql: Change data type of counters in BufferUsage and WalUsage from lo

2021-05-11 Thread Fujii Masao
Change data type of counters in BufferUsage and WalUsage from long to int64. Previously long was used as the data type for some counters in BufferUsage and WalUsage. But long is only four byte, e.g., on Windows, and it's entirely possible to wrap a four byte counter. For example, emitting more

Re: pgsql: Add support for LZ4 build in MSVC scripts

2021-05-11 Thread Andrew Dunstan
On 5/10/21 9:44 PM, Michael Paquier wrote: > Add support for LZ4 build in MSVC scripts > > Since its introduction in bbe0a81, compression of table data supports > LZ4, but nothing had been done within the MSVC scripts to allow users to > build the code with this library. > > This commit closes

pgsql: Tweak generation of Gen_dummy_probes.pl

2021-05-11 Thread Andrew Dunstan
Tweak generation of Gen_dummy_probes.pl Use a static prolog file instead of generating the prolog from the existing perl script. Also, support generation of the file in a vpath build. Discussion: https://postgr.es/m/700620.1620662...@sss.pgh.pa.us Branch -- master Details ---

pgsql: Fix vcregress.pl's ancient misspelling of --max-connections.

2021-05-11 Thread Tom Lane
Fix vcregress.pl's ancient misspelling of --max-connections. I copied the existing spelling of "--max_connections", but that's just wrong :-(. Evidently setting $ENV{MAX_CONNECTIONS} has never actually worked in this script. Given the lack of complaints, it's probably not worth back-patching a

pgsql: Tag refs/tags/REL_10_17 was created

2021-05-11 Thread noreply
Tag refs/tags/REL_10_17 was created.

pgsql: Tag refs/tags/REL_12_7 was created

2021-05-11 Thread noreply
Tag refs/tags/REL_12_7 was created.

pgsql: Tag refs/tags/REL_11_12 was created

2021-05-11 Thread noreply
Tag refs/tags/REL_11_12 was created.

pgsql: Tag refs/tags/REL9_6_22 was created

2021-05-11 Thread noreply
Tag refs/tags/REL9_6_22 was created.

pgsql: Tag refs/tags/REL_13_3 was created

2021-05-11 Thread noreply
Tag refs/tags/REL_13_3 was created.

pgsql: Get rid of the separate serial_schedule list of tests.

2021-05-11 Thread Tom Lane
Get rid of the separate serial_schedule list of tests. Having to maintain two lists of regression test scripts has proven annoyingly error-prone. We can achieve the effect of the serial_schedule by running the parallel_schedule with "--max_connections=1"; so do that and remove serial_schedule.

pgsql: doc: update PG 14 release notes based on feedback

2021-05-11 Thread Bruce Momjian
doc: update PG 14 release notes based on feedback Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/5b2d09beaffa915edd6e74fcf030b13844d3326f Modified Files -- doc/src/sgml/release-14.sgml | 216 +-- 1 file changed,

pgsql: Replace opr_sanity test's binary_coercible() function with C cod

2021-05-11 Thread Tom Lane
Replace opr_sanity test's binary_coercible() function with C code. opr_sanity's binary_coercible() function has always been meant to match the parser's notion of binary coercibility, but it also has always been a rather poor approximation of the parser's real rules (as embodied in

pgsql: Fix typo

2021-05-11 Thread Peter Eisentraut
Fix typo Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6d177e2813a2b4415539e2861b595583cc1a8f71 Modified Files -- src/backend/parser/parse_cte.c | 2 +- src/test/regress/expected/with.out | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-)