pgsql: Fix comment in psql's describe.c

2019-09-10 Thread Michael Paquier
Fix comment in psql's describe.c Procedures are supported since v11 and \dfp can be used since this version, but it was not mentioned as a supported option in the description of describeFunctions() which handles \df in psql. Extracted from a larger patch. Author: Fabien Coelho Discussion: https:

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Expand properly list of TAP tests used for prove in vcregress.pl

2019-09-10 Thread Michael Paquier
Expand properly list of TAP tests used for prove in vcregress.pl Depending on the system used, t/*.pl may not be expanded into a list of tests which can be consumed by prove when attempting to run TAP tests on a given path. Fix that by using glob() directly in the script, to make sure that a comp

pgsql: Allow setting statistics target for extended statistics

2019-09-10 Thread Tomas Vondra
Allow setting statistics target for extended statistics When building statistics, we need to decide how many rows to sample and how accurate the resulting statistics should be. Until now, it was not possible to explicitly define statistics target for extended statistics objects, the value was alwa

pgsql: Tag refs/tags/REL_12_BETA4 was created

2019-09-10 Thread noreply
Tag refs/tags/REL_12_BETA4 was created.

pgsql: Reduce overhead of scanning the backend[] array in LISTEN/NOTIFY

2019-09-10 Thread Tom Lane
Reduce overhead of scanning the backend[] array in LISTEN/NOTIFY. Up to now, async.c scanned its whole array of per-backend state whenever it needed to find listening backends. That's expensive if MaxBackends is large, so extend the data structure with list links that thread the active entries to

pgsql: Fix unaccent generation script in Windows

2019-09-10 Thread Alvaro Herrera
Fix unaccent generation script in Windows As originally coded, the script would fail on Windows 10 and Python 3 because stdout would not be switched to UTF-8 only for Python 2. This patch makes that apply to both versions. Also add python 2 compatibility markers so that we know what to remove on

pgsql: Sync isolationtester's handling of notice/warning messages with

2019-09-10 Thread Tom Lane
Sync isolationtester's handling of notice/warning messages with HEAD. Back-patch relevant parts of these commits: 30717637c Fix isolationtester race condition for notices sent before blocking ebd499282 Don't drop NOTICE messages in isolation tests a28e10e82 Indicate session name in isolationtester

pgsql: Sync isolationtester's handling of notice/warning messages with

2019-09-10 Thread Tom Lane
Sync isolationtester's handling of notice/warning messages with HEAD. Back-patch relevant parts of these commits: 30717637c Fix isolationtester race condition for notices sent before blocking ebd499282 Don't drop NOTICE messages in isolation tests a28e10e82 Indicate session name in isolationtester

pgsql: Sync isolationtester's handling of notice/warning messages with

2019-09-10 Thread Tom Lane
Sync isolationtester's handling of notice/warning messages with HEAD. Back-patch relevant parts of these commits: 30717637c Fix isolationtester race condition for notices sent before blocking ebd499282 Don't drop NOTICE messages in isolation tests a28e10e82 Indicate session name in isolationtester

pgsql: Don't drop NOTICE messages in isolation tests.

2019-09-10 Thread Tom Lane
Don't drop NOTICE messages in isolation tests. For its entire existence, isolationtester.c has forced client_min_messages to WARNING, but that seems like a very poor choice of test design. It should be up to individual test scripts to manage whether they emit notices and to ensure that the result

Re: pgsql: Reorder EPQ work, to fix rowmark related bugs and improve effici

2019-09-10 Thread Tom Lane
Andres Freund writes: > On 2019-09-09 22:13:22 -0400, Tom Lane wrote: >> Alvaro Herrera writes: >>> As well as a28e10e82e54, I suppose. I agree with keeping the tool >>> similar across branches, if we're going to do this. >> Hm, good point. My first thought was that a28e10e82e54 is just >> cos

pgsql: Restructure libpq code to remove some duplicity

2019-09-10 Thread Alvaro Herrera
Restructure libpq code to remove some duplicity There was some duplicate code to run SHOW transaction_read_only to determine whether the server is read-write or read-only. Reduce it by adding another state to the state machine. Author: Hari Babu Kommi Reviewed-by: Takayuki Tsunakawa, Álvaro Herr

Re: pgsql: Reorder EPQ work, to fix rowmark related bugs and improve effici

2019-09-10 Thread Andres Freund
Hi, On 2019-09-09 22:13:22 -0400, Tom Lane wrote: > Alvaro Herrera writes: > > On 2019-Sep-09, Tom Lane wrote: > >> It appears to me that this is indeed a case of notice-reporting > >> timing problems in isolationtester, since these WARNING messages > >> are handled the same way as notices. I wa