pgsql: Rename cryptohashes.c to cryptohashfuncs.c

2020-12-03 Thread Michael Paquier
Rename cryptohashes.c to cryptohashfuncs.c 87ae969 has created two new files called cryptohash{_openssl}.c in src/common/, whose names overlap with the existing backend file called cryptohashes.c dedicated to the SQL wrappers for SHA2 and MD5. This file is renamed to cryptohashfuncs.c to be more

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

2020-12-03 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. This takes advantage of the refactoring done in 87ae969 that has introduced the

pgsql: doc: remove unnecessary blank before command option text

2020-12-03 Thread Bruce Momjian
doc: remove unnecessary blank before command option text Backpatch-through: 11 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7b0bd08a325fd4f21269dbc9a6dd82809342644d Modified Files -- doc/src/sgml/ref/pg_checksums.sgml | 2 +-

pgsql: doc: remove unnecessary blank before command option text

2020-12-03 Thread Bruce Momjian
doc: remove unnecessary blank before command option text Backpatch-through: 11 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f3f033a28426796653cadbc576fe83ec3ab60673 Modified Files -- doc/src/sgml/ref/pg_checksums.sgml | 2 +-

pgsql: doc: remove unnecessary blank before command option text

2020-12-03 Thread Bruce Momjian
doc: remove unnecessary blank before command option text Backpatch-through: 11 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3f8971d92e767acf6e3d6e27c4cab7bfd88b71f4 Modified Files -- doc/src/sgml/ref/pg_checksums.sgml | 2 +-

pgsql: doc: remove unnecessary blank before command option text

2020-12-03 Thread Bruce Momjian
doc: remove unnecessary blank before command option text Backpatch-through: 11 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/aee1f7496113bfe5e7ea6acdef49b86405507a83 Modified Files -- doc/src/sgml/ref/pg_controldata.sgml | 2 +-

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: docs: list single-letter options first in command-line summary

2020-12-03 Thread Bruce Momjian
docs: list single-letter options first in command-line summary In a few places, the long-version options were listed before the single-letter ones in the command summary of a few commands. This didn't match other commands, and didn't match the option ordering later in the same reference page.

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Fix pg_rewind bugs when rewinding a standby server.

2020-12-03 Thread Heikki Linnakangas
Fix pg_rewind bugs when rewinding a standby server. If the target is a standby server, its WAL doesn't end at the last checkpoint record, but at minRecoveryPoint. We must scan all the WAL from the last common checkpoint all the way up to minRecoveryPoint for modified pages, and also consider that

pgsql: Small code simplifications

2020-12-03 Thread Peter Eisentraut
Small code simplifications strVal() can be used in a couple of places instead of coding the same thing by hand. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6114040711affa2b0bcf47fa2791187daf8455fb Modified Files -- src/backend/foreign/foreign.c | 2

pgsql: Improve estimation of OR clauses using extended statistics.

2020-12-03 Thread Dean Rasheed
Improve estimation of OR clauses using extended statistics. Formerly we only applied extended statistics to an OR clause as part of the clauselist_selectivity() code path for an OR clause appearing in an implicitly-ANDed list of clauses. This meant that it could only use extended statistics if