pgsql: Portability fix for zic.c.

2019-04-26 Thread Tom Lane
Portability fix for zic.c. Missed an inttypes.h dependency in previous patch. Per buildfarm. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b3904abb4d43f59749438735ab3ce3227e9b61b8 Modified Files -- src/timezone/README | 2 ++ src/timezone/zic.c

pgsql: Portability fix for zic.c.

2019-04-26 Thread Tom Lane
Portability fix for zic.c. Missed an inttypes.h dependency in previous patch. Per buildfarm. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7c22e1388420694654c63b2992695a8be2ac3a07 Modified Files -- src/timezone/README | 2 ++ src/timezone/zic.c

pgsql: Portability fix for zic.c.

2019-04-26 Thread Tom Lane
Portability fix for zic.c. Missed an inttypes.h dependency in previous patch. Per buildfarm. Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1c61ec7bb14ee0c6064f54a2ddaaedc3537db581 Modified Files -- src/timezone/README | 2 ++ src/timezone/zic.c

pgsql: Portability fix for zic.c.

2019-04-26 Thread Tom Lane
Portability fix for zic.c. Missed an inttypes.h dependency in previous patch. Per buildfarm. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/48f8fa9ce0f9799c8ae8bcd23c498fe002d5496d Modified Files -- src/timezone/README | 2 ++ src/timezone/zic.c | 6 +

pgsql: Portability fix for zic.c.

2019-04-26 Thread Tom Lane
Portability fix for zic.c. Missed an inttypes.h dependency in previous patch. Per buildfarm. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/578cb33dfbf4757478b1856d5a5726915270e95d Modified Files -- src/timezone/README | 2 ++ src/timezone/zic.c

pgsql: Portability fix for zic.c.

2019-04-26 Thread Tom Lane
Portability fix for zic.c. Missed an inttypes.h dependency in previous patch. Per buildfarm. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a97cfd9b829158ba4d9be866c65d0937b7d3519d Modified Files -- src/timezone/README | 2 ++ src/timezone/zic.c

pgsql: Mention REINDEX CONCURRENTLY in documentation about index mainte

2019-04-26 Thread Michael Paquier
Mention REINDEX CONCURRENTLY in documentation about index maintenance The documentation includes a section about index maintenance and reindexing, mentioning a set of steps based on CREATE INDEX CONCURRENTLY and ALTER TABLE (for constraint dependencies) to emulate REINDEX CONCURRENTLY. Now that R

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

2019-04-26 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019a. This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone. More interestingly, zic has grown a "-r" option that limits the range of zone transitions that it will pu

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

2019-04-26 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019a. This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone. More interestingly, zic has grown a "-r" option that limits the range of zone transitions that it will pu

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

2019-04-26 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019a. This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone. More interestingly, zic has grown a "-r" option that limits the range of zone transitions that it will pu

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

2019-04-26 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019a. This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone. More interestingly, zic has grown a "-r" option that limits the range of zone transitions that it will pu

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

2019-04-26 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019a. This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone. More interestingly, zic has grown a "-r" option that limits the range of zone transitions that it will pu

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

2019-04-26 Thread Tom Lane
Sync our copy of the timezone library with IANA release tzcode2019a. This corrects a small bug in zic that caused it to output an incorrect year-2440 transition in the Africa/Casablanca zone. More interestingly, zic has grown a "-r" option that limits the range of zone transitions that it will pu

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

2019-04-26 Thread Tom Lane
Update time zone data files to tzdata release 2019a. DST law changes in Palestine and Metlakatla. Historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation "UCT", which nowadays is typically a typo.

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

2019-04-26 Thread Tom Lane
Update time zone data files to tzdata release 2019a. DST law changes in Palestine and Metlakatla. Historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation "UCT", which nowadays is typically a typo.

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

2019-04-26 Thread Tom Lane
Update time zone data files to tzdata release 2019a. DST law changes in Palestine and Metlakatla. Historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation "UCT", which nowadays is typically a typo.

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

2019-04-26 Thread Tom Lane
Update time zone data files to tzdata release 2019a. DST law changes in Palestine and Metlakatla. Historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation "UCT", which nowadays is typically a typo.

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

2019-04-26 Thread Tom Lane
Update time zone data files to tzdata release 2019a. DST law changes in Palestine and Metlakatla. Historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation "UCT", which nowadays is typically a typo.

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

2019-04-26 Thread Tom Lane
Update time zone data files to tzdata release 2019a. DST law changes in Palestine and Metlakatla. Historical corrections for Israel. Etc/UCT is now a backward-compatibility link to Etc/UTC, instead of being a separate zone that generates the abbreviation "UCT", which nowadays is typically a typo.

pgsql: Update key words table for version 12

2019-04-26 Thread Peter Eisentraut
Update key words table for version 12 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/686fef22fdba732aeca28b471a362d4fb5675675 Modified Files -- doc/src/sgml/keywords.sgml | 7 +++ 1 file changed, 7 insertions(+)

pgsql: Apply stopgap fix for bug #15672.

2019-04-26 Thread Tom Lane
Apply stopgap fix for bug #15672. Fix DefineIndex so that it doesn't attempt to pass down a to-be-reused index relfilenode to a child index creation, and fix TryReuseIndex to not think that reuse is sensible for a partitioned index. In v11, this fixes a problem where ALTER TABLE on a partitioned

pgsql: Apply stopgap fix for bug #15672.

2019-04-26 Thread Tom Lane
Apply stopgap fix for bug #15672. Fix DefineIndex so that it doesn't attempt to pass down a to-be-reused index relfilenode to a child index creation, and fix TryReuseIndex to not think that reuse is sensible for a partitioned index. In v11, this fixes a problem where ALTER TABLE on a partitioned

pgsql: pg_dump: store unused attribs as NULL instead of '\0'

2019-04-26 Thread Alvaro Herrera
pg_dump: store unused attribs as NULL instead of '\0' Commit f831d4accda0 changed pg_dump to emit (and pg_restore to understand) NULLs for unused members in ArchiveEntry structs, as a side effect of some code beautification. That broke pg_restore of dumps generated with older pg_dump, however, so

pgsql: doc: Update section on NFS

2019-04-26 Thread Peter Eisentraut
doc: Update section on NFS The old section was ancient and didn't seem very helpful. Here, we add some concrete advice on particular mount options. Reviewed-by: Joe Conway Discussion: https://www.postgresql.org/message-id/flat/e90f24bb-5423-6abb-58ec-501176eb4afc%402ndquadrant.com Branch

Re: pgsql: Allow insert and update tuple routing and COPY for foreign table

2019-04-26 Thread Etsuro Fujita
(2019/04/26 13:58), Etsuro Fujita wrote: (2019/04/26 13:20), Amit Langote wrote: + Note that this function is also called when inserting routed tuples into + a foreign-table partition or executingCOPY FROM on + a foreign table, in which case it is called in a different way than it + is in theINS

pgsql: Add FDW documentation notes about insert and update tuple routin

2019-04-26 Thread Etsuro Fujita
Add FDW documentation notes about insert and update tuple routing and COPY. Author: Laurenz Albe and Etsuro Fujita Reviewed-by: Laurenz Albe and Amit Langote Backpatch-through: 11 where support for that by FDWs was added Discussion: https://postgr.es/m/bf36a0288e8f31b4f2f40952e225bf892dc1ffc5.ca.

pgsql: Add FDW documentation notes about insert and update tuple routin

2019-04-26 Thread Etsuro Fujita
Add FDW documentation notes about insert and update tuple routing and COPY. Author: Laurenz Albe and Etsuro Fujita Reviewed-by: Laurenz Albe and Amit Langote Backpatch-through: 11 where support for that by FDWs was added Discussion: https://postgr.es/m/bf36a0288e8f31b4f2f40952e225bf892dc1ffc5.ca.