pgsql: Add collation versions for FreeBSD.

2020-11-20 Thread Thomas Munro
Add collation versions for FreeBSD.

On FreeBSD 13, use querylocale() to read the current version of libc
collations.  Similar to commits 352f6f2d for Windows and d5ac14f9 for
GNU/Linux.

Discussion: 
https://postgr.es/m/CAEepm%3D0uEQCpfq_%2BLYFBdArCe4Ot98t1aR4eYiYTe%3DyavQygiQ%40mail.gmail.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/ca051d8b101d3205f1c5faf0d1da8a523ffc95a1

Modified Files
--
doc/src/sgml/charset.sgml |  3 ++-
src/backend/utils/adt/pg_locale.c | 20 
2 files changed, 22 insertions(+), 1 deletion(-)



pgsql: Replace a macro by a function

2020-11-20 Thread Peter Eisentraut
Replace a macro by a function

Using a macro is ugly and not justified here.

Discussion: 
https://www.postgresql.org/message-id/flat/[email protected]

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/b5acf10cfc63ed1e0bc4eef466c0f4670a725ef3

Modified Files
--
src/backend/access/transam/xlog.c | 21 +++--
1 file changed, 11 insertions(+), 10 deletions(-)



pgsql: Remove ability to independently select random number generator

2020-11-20 Thread Magnus Hagander
Remove ability to independently select random number generator

Remove the ability to select random number generator independently from
SSL library. Instead, use the random number generator from the SSL
library (today only OpenSSL supported) if one is configured. If no SSL
library is configured, use the platform default (which means use
CryptoAPI on Win32 and /dev/urandom on Linux).

This also restructures pg_strong_random.c to have three clearly separate
sections, one for each implementation, with two functions in each,
instead of a scattered set of ifdefs throughout the whole file.

Author: Daniel Gustafsson, Magnus Hagander, Michael Paquier
Discussion: https://postgr.es/m/[email protected]

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/16f96c74d48e65da23d28665103e2c4c9d3414cc

Modified Files
--
configure   |  61 +-
configure.ac|  41 +++--
src/include/pg_config.h.in  |   9 --
src/port/pg_strong_random.c | 201 ++--
src/tools/msvc/Solution.pm  |   3 -
5 files changed, 114 insertions(+), 201 deletions(-)



pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-20 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.

Author: Alexey Bashtanov
Discussion: 
https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

Branch
--
REL_12_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/888fa2baeb39fa4069b1b2c0ced85b533313

Modified Files
--
src/backend/executor/nodeAgg.c | 6 +-
1 file changed, 5 insertions(+), 1 deletion(-)



pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-20 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.

Author: Alexey Bashtanov
Discussion: 
https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/57b5d8484c8a0949c3fa8205a324ac7bf3a377fb

Modified Files
--
src/backend/executor/nodeAgg.c | 6 +-
1 file changed, 5 insertions(+), 1 deletion(-)



pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-20 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.

Author: Alexey Bashtanov
Discussion: 
https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

Branch
--
REL_13_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/340ae3cfb8f38a49664c0da3ff033346e92f0450

Modified Files
--
src/backend/executor/nodeAgg.c | 6 +-
1 file changed, 5 insertions(+), 1 deletion(-)



pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-20 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.

Author: Alexey Bashtanov
Discussion: 
https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/1dbe627fd6bf889ad117a706ff474f7382a66465

Modified Files
--
src/backend/executor/nodeAgg.c | 6 +-
1 file changed, 5 insertions(+), 1 deletion(-)



pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-20 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.

Author: Alexey Bashtanov
Discussion: 
https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

Branch
--
REL9_6_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/02a2dbe91d37e521fb0dbeebc79ee9edd051f950

Modified Files
--
src/backend/executor/nodeAgg.c | 5 -
1 file changed, 4 insertions(+), 1 deletion(-)



pgsql: Skip allocating hash table in EXPLAIN-only mode.

2020-11-20 Thread Heikki Linnakangas
Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.

Author: Alexey Bashtanov
Discussion: 
https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

Branch
--
REL9_5_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/ded7db4c1dddcead3184b17619ddc5c203db42fe

Modified Files
--
src/backend/executor/nodeAgg.c | 5 -
1 file changed, 4 insertions(+), 1 deletion(-)



pgsql: Make pg_rewind test case more stable.

2020-11-20 Thread Heikki Linnakangas
Make pg_rewind test case more stable.

If replication is exceptionally slow for some reason, pg_rewind might run
before the test row has been replicated. Add an explicit wait for it.

Reported-by: Andres Freund
Discussion: 
https://www.postgresql.org/message-id/20201120003811.iknhqwatitw2vvxf%40alap3.anarazel.de

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/c71f9a094b32770dcd34b9ba4909435e34583747

Modified Files
--
src/bin/pg_rewind/t/007_standby_source.pl | 4 
1 file changed, 4 insertions(+)



pgsql: doc: Improve tableoid description

2020-11-20 Thread Peter Eisentraut
doc: Improve tableoid description

Mention that it's useful for determining table names for partitioned
tables as well as for those in inheritance hierarchies.

Author: Ian Lawrence Barwick 
Reviewed-by: Ashutosh Bapat 
Discussion: 
https://www.postgresql.org/message-id/flat/CAB8KJ=gFmBXP=p9htzioj+wm5pdak4qc7igqta+8kuh306k...@mail.gmail.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/a47834db0fb70256e676862f1d96374a9e114d82

Modified Files
--
doc/src/sgml/ddl.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)