pgsql: Change SHA2 implementation based on OpenSSL to use EVP digest ro

2020-09-27 Thread Michael Paquier
Change SHA2 implementation based on OpenSSL to use EVP digest routines The use of low-level hash routines is not recommended by upstream OpenSSL since 2000, and pgcrypto already switched to EVP as of 5ff4a67. Note that this also fixes a failure with SCRAM authentication when using FIPS in OpenSSL,

pgsql: Minor mop-up for List improvements.

2020-09-27 Thread Tom Lane
Minor mop-up for List improvements. Fix a few places that were using written-out versions of the pg_list.h macros that commit cc99baa43 just improved, making them also use those macros so as to gain whatever performance improvement is to be had. Discussion: https://postgr.es/m/caaphdvpo1zj9khepu

pgsql: Improve tab-completion for DEALLOCATE.

2020-09-27 Thread Fujii Masao
Improve tab-completion for DEALLOCATE. Author: Naoki Nakamichi Reviewed-by: Fujii Masao Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0baf82fa0cbe98fe317483f1e1c6612fc41e1dad Modifie

pgsql: Improve pg_list.h's linitial(), lsecond() and co macros

2020-09-27 Thread David Rowley
Improve pg_list.h's linitial(), lsecond() and co macros Prior to this commit, the linitial(), lsecond(), lthird(), lfourth() macros and their int and Oid list cousins would call their corresponding inlined function to fetch the cell of interest. Those inline functions were kind enough to return N

pgsql: Improve range checks of options for pg_test_fsync and pg_test_ti

2020-09-27 Thread Michael Paquier
Improve range checks of options for pg_test_fsync and pg_test_timing Both tools never had safeguard checks for the options provided, and it was possible to make pg_test_fsync run an infinite amount of time or pass down buggy values to pg_test_timing. These behaviors have existed for a long time,

pgsql: Move resolution of AlternativeSubPlan choices to the planner.

2020-09-27 Thread Tom Lane
Move resolution of AlternativeSubPlan choices to the planner. When commit bd3daddaf introduced AlternativeSubPlans, I had some ambitions towards allowing the choice of subplan to change during execution. That has not happened, or even been thought about, in the ensuing twelve years; so it seems l