pgsql: Fix initialization of es_result_relations in EvalPlanQualStart()

2020-10-22 Thread Heikki Linnakangas
Fix initialization of es_result_relations in EvalPlanQualStart(). Thinko in commit 1375422c782. EvalPlanQualStart() was mistakenly resetting the parent EState's es_result_relations, when it should initialize the field in the child EPQ EState it just created. That was clearly wrong, but it didn't

pgsql: Improve performance of Unicode {de,re}composition in the backend

2020-10-22 Thread Michael Paquier
Improve performance of Unicode {de,re}composition in the backend This replaces the existing binary search with two perfect hash functions for the composition and the decomposition in the backend code, at the cost of slightly-larger binaries there (35kB in libpgcommon_srv.a). Per the measurements

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/96ed2ae9360d9b89f695f00c2b6417c4e4d9fcba Mod

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/05a36321a70e180168cd58a2e20313163c007623 Mod

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7d6d6bce43c60bb7b77237e2cc6ab845646b911f Modified F

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a357cc05ddd9853302583c5f23f6e338ee3a611f Mod

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/78ccf7f42b98add6528ae99ea2c2198b6c574c65 Mod

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/02f86d52382c3de5e3e506f6bd030a14886d2cff Mod

pgsql: Update time zone data files to tzdata release 2020d.

2020-10-22 Thread Tom Lane
Update time zone data files to tzdata release 2020d. DST law changes in Palestine, with a whopping 120 hours' notice. Also some historical corrections for Palestine. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/0abebb58f522b190b208c31e704b60ea5b6f0a28 Mod

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

2020-10-22 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2020d. There's no functional change at all here, but I'm curious to see whether this change successfully shuts up Coverity's warning about a useless strcmp(), which appeared with the previous update. Discussion: http://mm.icann.org/pip

pgsql: Avoid premature de-doubling of quote marks in ECPG strings.

2020-10-22 Thread Tom Lane
Avoid premature de-doubling of quote marks in ECPG strings. If you write the literal 'abc''def' in an EXEC SQL command, that will come out the other end as 'abc'def', triggering a syntax error in the backend. Likewise, "abc""def" is reduced to "abc"def" which is wrong syntax for a quoted identifi

pgsql: Add documentation and tests for quote marks in ECPG literal quer

2020-10-22 Thread Tom Lane
Add documentation and tests for quote marks in ECPG literal queries. ECPG's PREPARE ... FROM and EXECUTE IMMEDIATE can optionally take the target query as a simple literal, rather than the more usual string-variable reference. This was previously documented as being a C string literal, but that's

pgsql: Try to avoid a compiler warning about using fxid uninitialized.

2020-10-22 Thread Robert Haas
Try to avoid a compiler warning about using fxid uninitialized. Mark Dilger, with a couple of stray semicolons removed by me. Discussion: http://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/8bb0c

pgsql: Clean up some unpleasant behaviors in psql's \connect command.

2020-10-22 Thread Tom Lane
Clean up some unpleasant behaviors in psql's \connect command. The check for whether to complain about not having an old connection to get parameters from was seriously out of date: it had not been rethought when we invented connstrings, nor when we invented the -reuse-previous option. Replace it

pgsql: Extend amcheck to check heap pages.

2020-10-22 Thread Robert Haas
Extend amcheck to check heap pages. Mark Dilger, reviewed by Peter Geoghegan, Andres Freund, Álvaro Herrera, Michael Paquier, Amul Sul, and by me. Some last-minute cosmetic revisions by me. Discussion: http://postgr.es/m/[email protected] Branch -- master

pgsql: Use croak instead of die in Perl code when appropriate

2020-10-22 Thread Peter Eisentraut
Use croak instead of die in Perl code when appropriate Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f8721bd752790859df747905bc44fb5ad8dbf07d Modified Files -- src/test/perl/TestLib.pm | 13 +++-- 1 file changed, 7 insertions(+), 6 deletions(-)