pgsql: Fix varchar_2.out to match reality in cs_CZ locale.

2020-12-15 Thread Tom Lane
Fix varchar_2.out to match reality in cs_CZ locale. Seems to be a copy-and-pasteo in c06d6aa4c. Per buildfarm. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/88e014c149cc396fb218b08eda17c47d5b33e94f Modified Files -- src/test/regress/expected/varchar_

pgsql: doc: Fix explanation related to pg_shmem_allocations

2020-12-15 Thread Michael Paquier
doc: Fix explanation related to pg_shmem_allocations Offsets are shown as NULL only for anonymous allocations. Author: Benoit Lobréau Reviewed-by: Kyotaro Horiguchi Discussion: https://postgr.es/m/cape8ez5lnoyqoz7azpvqm0e8sw+hw+k6g2nule+m4arfrra...@mail.gmail.com Backpatch-through: 13 Branch --

pgsql: doc: Fix explanation related to pg_shmem_allocations

2020-12-15 Thread Michael Paquier
doc: Fix explanation related to pg_shmem_allocations Offsets are shown as NULL only for anonymous allocations. Author: Benoit Lobréau Reviewed-by: Kyotaro Horiguchi Discussion: https://postgr.es/m/cape8ez5lnoyqoz7azpvqm0e8sw+hw+k6g2nule+m4arfrra...@mail.gmail.com Backpatch-through: 13 Branch --

pgsql: doc: clarify COPY TO for partitioning/inheritance

2020-12-15 Thread Bruce Momjian
doc: clarify COPY TO for partitioning/inheritance It was not clear how COPY TO behaved with partitioning/inheritance because the paragraphs were so far apart. Also reword to simplify. Discussion: https://postgr.es/m/[email protected] Author: Justin Pryzby Backpatch-through:

pgsql: doc: clarify COPY TO for partitioning/inheritance

2020-12-15 Thread Bruce Momjian
doc: clarify COPY TO for partitioning/inheritance It was not clear how COPY TO behaved with partitioning/inheritance because the paragraphs were so far apart. Also reword to simplify. Discussion: https://postgr.es/m/[email protected] Author: Justin Pryzby Backpatch-through:

pgsql: doc: clarify COPY TO for partitioning/inheritance

2020-12-15 Thread Bruce Momjian
doc: clarify COPY TO for partitioning/inheritance It was not clear how COPY TO behaved with partitioning/inheritance because the paragraphs were so far apart. Also reword to simplify. Discussion: https://postgr.es/m/[email protected] Author: Justin Pryzby Backpatch-through:

pgsql: doc: clarify COPY TO for partitioning/inheritance

2020-12-15 Thread Bruce Momjian
doc: clarify COPY TO for partitioning/inheritance It was not clear how COPY TO behaved with partitioning/inheritance because the paragraphs were so far apart. Also reword to simplify. Discussion: https://postgr.es/m/[email protected] Author: Justin Pryzby Backpatch-through:

pgsql: doc: clarify COPY TO for partitioning/inheritance

2020-12-15 Thread Bruce Momjian
doc: clarify COPY TO for partitioning/inheritance It was not clear how COPY TO behaved with partitioning/inheritance because the paragraphs were so far apart. Also reword to simplify. Discussion: https://postgr.es/m/[email protected] Author: Justin Pryzby Backpatch-through:

pgsql: Remove obsolete btrescan() comment.

2020-12-15 Thread Peter Geoghegan
Remove obsolete btrescan() comment. "Ordering stuff" refered to a _bt_first() call to _bt_orderkeys(). However, the _bt_orderkeys() function was renamed to _bt_preprocess_keys() by commit fa5c8a055a0. _bt_preprocess_keys() is directly referenced just after the removed comment already, which seems

pgsql: Remove useless variable stores

2020-12-15 Thread Alvaro Herrera
Remove useless variable stores Mistakenly introduced in 4cbe3ac3e867; bug repaired in 148e632c0541 but the stores were accidentally. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a18422a3adf79815fecb50a029b63a8e85ca9d21 Modified Files -- src/backend/e

pgsql: Error out when Gather Merge input is not sorted

2020-12-15 Thread Tomas Vondra
Error out when Gather Merge input is not sorted To build Gather Merge path, the input needs to be sufficiently sorted. Ensuring this is the responsibility of the code constructing the paths, but create_gather_merge_plan tried to handle unsorted paths by adding an explicit Sort. In light of the rec

pgsql: Clean up ancient test style

2020-12-15 Thread Peter Eisentraut
Clean up ancient test style Many older tests where written in a style like SELECT '' AS two, i.* FROM INT2_TBL where the first column indicated the number of expected result rows. This has gotten increasingly out of date, as the test data fixtures have expanded, so a lot of these were wrong

pgsql: Improve hash_create()'s API for some added robustness.

2020-12-15 Thread Tom Lane
Improve hash_create()'s API for some added robustness. Invent a new flag bit HASH_STRINGS to specify C-string hashing, which was formerly the default; and add assertions insisting that exactly one of the bits HASH_STRINGS, HASH_BLOBS, and HASH_FUNCTION be set. This is in hopes of preventing recurr

pgsql: Use native methods to open input in TestLib::slurp_file on Windo

2020-12-15 Thread Andrew Dunstan
Use native methods to open input in TestLib::slurp_file on Windows. This is a backport of commits 114541d58e and 6f59826f0 to the remaining live branches. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/da7edca4630c5bcf7c0f0f5819ab6fb020d3c845 Modified Files

pgsql: Use native methods to open input in TestLib::slurp_file on Windo

2020-12-15 Thread Andrew Dunstan
Use native methods to open input in TestLib::slurp_file on Windows. This is a backport of commits 114541d58e and 6f59826f0 to the remaining live branches. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f57c6cdbadd32050b860e66c4fec7823d59319da Modified Files

pgsql: Use native methods to open input in TestLib::slurp_file on Windo

2020-12-15 Thread Andrew Dunstan
Use native methods to open input in TestLib::slurp_file on Windows. This is a backport of commits 114541d58e and 6f59826f0 to the remaining live branches. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/bf88c6d6021c1abbc73197803c98dad0f033b462 Modified Files

pgsql: Use native methods to open input in TestLib::slurp_file on Windo

2020-12-15 Thread Andrew Dunstan
Use native methods to open input in TestLib::slurp_file on Windows. This is a backport of commits 114541d58e and 6f59826f0 to the remaining live branches. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b5eb07ed78a0e52b392c9b64e01e044a45c1fdb6 Modified Files

pgsql: Use native methods to open input in TestLib::slurp_file on Windo

2020-12-15 Thread Andrew Dunstan
Use native methods to open input in TestLib::slurp_file on Windows. This is a backport of commits 114541d58e and 6f59826f0 to the remaining live branches. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/355f9d2452dc93563fd89cac4b858d9e3f8e5960 Modified Files