pgsql: Fix recovery conflict in 027_stream_regress.pl.

2022-02-01 Thread Thomas Munro
Fix recovery conflict in 027_stream_regress.pl. To avoid "ERROR: canceling statement due to conflict with recovery", as seen on a couple of slower build farm animals, crank max_standby_streaming_delay right up. In passing, adjust a configuration option that accidentally used a non-standard forma

Re: pgsql: plperl: windows: Use Perl_setlocale on 5.28+, fixing compile fai

2022-02-01 Thread Tom Lane
Andres Freund writes: > On 2022-01-31 15:08:30 -0500, Tom Lane wrote: >> Done now. > Thanks! Just for the archives' sake --- seems this broke pademelon [1]: cc -Ae -g +O0 -Wp,-H16384 +Z -I. -I. -I../../../src/include -D_XOPEN_SOURCE_EXTENDED -I/usr/local/libxml2-2.6.23/include/libxml2 -I/us

pgsql: Replace use of deprecated Python module distutils.sysconfig, tak

2022-02-01 Thread Tom Lane
Replace use of deprecated Python module distutils.sysconfig, take 2. With Python 3.10, configure spits out warnings about the module distutils.sysconfig being deprecated and scheduled for removal in Python 3.12. Change the uses in configure to use the module sysconfig instead. The logic stays la

pgsql: Replace use of deprecated Python module distutils.sysconfig, tak

2022-02-01 Thread Tom Lane
Replace use of deprecated Python module distutils.sysconfig, take 2. With Python 3.10, configure spits out warnings about the module distutils.sysconfig being deprecated and scheduled for removal in Python 3.12. Change the uses in configure to use the module sysconfig instead. The logic stays la

pgsql: Replace use of deprecated Python module distutils.sysconfig, tak

2022-02-01 Thread Tom Lane
Replace use of deprecated Python module distutils.sysconfig, take 2. With Python 3.10, configure spits out warnings about the module distutils.sysconfig being deprecated and scheduled for removal in Python 3.12. Change the uses in configure to use the module sysconfig instead. The logic stays la

pgsql: Replace use of deprecated Python module distutils.sysconfig, tak

2022-02-01 Thread Tom Lane
Replace use of deprecated Python module distutils.sysconfig, take 2. With Python 3.10, configure spits out warnings about the module distutils.sysconfig being deprecated and scheduled for removal in Python 3.12. Change the uses in configure to use the module sysconfig instead. The logic stays la

pgsql: Replace use of deprecated Python module distutils.sysconfig, tak

2022-02-01 Thread Tom Lane
Replace use of deprecated Python module distutils.sysconfig, take 2. With Python 3.10, configure spits out warnings about the module distutils.sysconfig being deprecated and scheduled for removal in Python 3.12. Change the uses in configure to use the module sysconfig instead. The logic stays la

pgsql: Treat case of tab-completion keywords a bit more carefully.

2022-02-01 Thread Tom Lane
Treat case of tab-completion keywords a bit more carefully. When completing keywords that are offered alongside names obtained from a query, preserve the user's choice of keyword case. This would have been messy to do before 02b8048ba, but now it's fairly simple. A complication is that we want k

pgsql: Doc: modernize documentation for lo_create()/lo_creat().

2022-02-01 Thread Tom Lane
Doc: modernize documentation for lo_create()/lo_creat(). At this point lo_creat() is a legacy function with little if any real use-case, so describing it first doesn't make much sense. Describe lo_create() first, and then explain lo_creat() as a backwards-compatibility alternative. Discussion: h