pgsql: doc: Spell checking

2019-07-04 Thread Peter Eisentraut
doc: Spell checking Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/594df378ffb04a72b713a13cc0a7166b3bced7b7 Modified Files -- doc/src/sgml/btree.sgml | 2 +- doc/src/sgml/client-auth.sgml | 4 ++-- doc/src/sgml/config.sgml | 8 doc/s

pgsql: doc: Spell checking

2019-07-04 Thread Peter Eisentraut
doc: Spell checking Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1970da1a0a7e9793d1676341fcb0c9a01f3db0dc Modified Files -- doc/src/sgml/btree.sgml | 2 +- doc/src/sgml/client-auth.sgml | 4 ++-- doc/src/sgml/config.sgml | 8 ---

pgsql: Add min() and max() aggregates for pg_lsn

2019-07-04 Thread Michael Paquier
Add min() and max() aggregates for pg_lsn This is useful for monitoring, when it comes for example to calculations of WAL retention with replication slots and delays with a set of standbys. Bump catalog version. Author: Fabrízio de Royes Mello Reviewed-by: Surafel Temesgen Discussion: https://p

pgsql: Update hardcoded DH parameters to IANA standards

2019-07-04 Thread Michael Paquier
Update hardcoded DH parameters to IANA standards The source defining the current fallback and hardcoded DH parameters has disappeared from the web a long time ago, and RFC 3526 defines the most current Diffie-Hellman MODP groups, so update to those new values. Author: Daniel Gustafsson Reviewed-b

pgsql: Simplify pg_mcv_list (de)serialization

2019-07-04 Thread Tomas Vondra
Simplify pg_mcv_list (de)serialization The serialization format of multivariate MCV lists included alignment in order to allow direct access to part of the serialized data, but despite multiple fixes (see for example commits d85e0f366a and ea4e1c0e8f) this proved to be problematic. This commit ab

pgsql: Fix pg_mcv_list_items() to produce text[]

2019-07-04 Thread Tomas Vondra
Fix pg_mcv_list_items() to produce text[] The function pg_mcv_list_items() returns values stored in MCV items. The items may contain columns with different data types, so the function was generating text array-like representation, but in an ad-hoc way without properly escaping various characters e

pgsql: Speed-up build of MCV lists with many distinct values

2019-07-04 Thread Tomas Vondra
Speed-up build of MCV lists with many distinct values When building multi-column MCV lists, we compute base frequency for each item, i.e. a product of per-column frequencies for values from the item. As a value may be in multiple groups, the code was scanning the whole array of groups while adding

pgsql: Remove unnecessary casts from size_t to int

2019-07-04 Thread Peter Eisentraut
Remove unnecessary casts from size_t to int We can use the %zu format specifier directly, no need to cast to int. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d5ab9df7774b4570ff50e64b7fa3ba8295596d06 Modified Files -- src/interfaces/ecpg/preproc/ecpg

pgsql: Unwind some workarounds for lack of portable int64 format specif

2019-07-04 Thread Peter Eisentraut
Unwind some workarounds for lack of portable int64 format specifier Because there is no portable int64/uint64 format specifier and we can't stick macros like INT64_FORMAT into the middle of a translatable string, we have been using various workarounds that put the number to be printed into a strin

pgsql: Sync our Snowball stemmer dictionaries with current upstream

2019-07-04 Thread Peter Eisentraut
Sync our Snowball stemmer dictionaries with current upstream The main change is a new stemmer for Greek. There are minor changes in the Danish and French stemmers. Author: Panagiotis Mavrogiorgos Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7b925e12703652fef63

pgsql: Clean up whitespace a bit

2019-07-04 Thread Peter Eisentraut
Clean up whitespace a bit Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/dedb6e0143554e76d4d11376d65c0aa68f8412d4 Modified Files -- src/backend/snowball/Makefile | 28 ++-- 1 file changed, 14 insertions(+), 14 deletions(-)

pgsql: Introduce safer encoding and decoding routines for base64.c

2019-07-04 Thread Michael Paquier
Introduce safer encoding and decoding routines for base64.c This is a follow-up refactoring after 09ec55b and b674211, which has proved that the encoding and decoding routines used by SCRAM have a poor interface when it comes to check after buffer overflows. This adds an extra argument in the sha