pgsql: Avoid using lcons and list_delete_first where it's easy to do so

2019-07-17 Thread Tom Lane
Avoid using lcons and list_delete_first where it's easy to do so. Formerly, lcons was about the same speed as lappend, but with the new List implementation, that's not so; with a long List, data movement imposes an O(N) cost on lcons and list_delete_first, but not lappend. Hence, invent list_dele

pgsql: Fix sepgsql test results for commit d97b714a2.

2019-07-17 Thread Tom Lane
Fix sepgsql test results for commit d97b714a2. The aggregate-order difference explained in my previous commit turns out to also affect the order of log entries emitted in the contrib/sepgsql regression test. Per buildfarm. Discussion: https://postgr.es/m/[email protected] Branch --

pgsql: Doc: explain where to find Makefile used to build sepgsql-regtes

2019-07-17 Thread Tom Lane
Doc: explain where to find Makefile used to build sepgsql-regtest.pp. At least on Fedora and RHEL, it's not in the same RPM that's needed for building sepgsql itself. Today is the second or third time I've had to rediscover how to install that, so let's document it this time. Branch -- maste

pgsql: Clarify the distinction between public and private SPITupleTable

2019-07-17 Thread Tom Lane
Clarify the distinction between public and private SPITupleTable fields. The fields that we consider public are "tupdesc" and "vals", which historically are in the middle of the struct. Move them to the front (this should be perfectly safe to do in HEAD) and add comments to make it quite clear wh

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Sync our copy of the timezone library with IANA release tzcode20

2019-07-17 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019b. A large fraction of this diff is just due to upstream's somewhat random decision to rename a bunch of internal variables and struct fields. However, there is an interesting new feature in zic: it's grown a "-b slim" option that

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/bcafb675a0097cbf3b437e04369ccd571a65fc46 Modified Files --

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/93907478e15f5762800b6acbe2eff03167843874 Modified Files -- sr

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8474656d993497c42caa68342c39d608f8854f8d Modified Files --

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d4f283162e8d09ca39085b2745e99543990e1d06 Modified Files --

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e3441b2a22b2d38f62b7bcbb10682de1acb0b2d6 Modified Files --

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a0c905f23d4c3f7ba647fb69a7e63fd07cdeabe0 Modified Files --

pgsql: Update time zone data files to tzdata release 2019b.

2019-07-17 Thread Tom Lane
Update time zone data files to tzdata release 2019b. Brazil no longer observes DST. Historical corrections for Palestine, Hong Kong, and Italy. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/53256e892e6bf747d4ad0250b6a803a294d3bc0e Modified Files --

pgsql: Simplify description of --data-checksums in documentation of ini

2019-07-17 Thread Michael Paquier
Simplify description of --data-checksums in documentation of initdb The documentation mentioned that data checksums cannot be changed after initialization, which is not true as pg_checksums can do that with its --enable option introduced in v12. This simply removes the sentence telling so. Repor

pgsql: Simplify description of --data-checksums in documentation of ini

2019-07-17 Thread Michael Paquier
Simplify description of --data-checksums in documentation of initdb The documentation mentioned that data checksums cannot be changed after initialization, which is not true as pg_checksums can do that with its --enable option introduced in v12. This simply removes the sentence telling so. Repor

pgsql: tableam: comment improvements.

2019-07-17 Thread Andres Freund
tableam: comment improvements. Author: Brad DeJong Discussion: https://postgr.es/m/CAJnrtnxDYOQFsDfWz2iri0T_fFL2ZbbzgCOE=4yamcszgcs...@mail.gmail.com Backpatch: 12- Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/fa7bb9345370ab69cac24b7213262f36567d9c9c Mod

pgsql: tableam: comment improvements.

2019-07-17 Thread Andres Freund
tableam: comment improvements. Author: Brad DeJong Discussion: https://postgr.es/m/CAJnrtnxDYOQFsDfWz2iri0T_fFL2ZbbzgCOE=4yamcszgcs...@mail.gmail.com Backpatch: 12- Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/21039555cdec75836d246fcbcd4b44ee63dabfad Modified F