[COMMITTERS] pgsql: Further 9.6 release note improvements.

2016-05-05 Thread Tom Lane
Further 9.6 release note improvements.

Call out the major enhancements in this release as identified by
pgsql-advocacy discussion, and rearrange some of the entries to
make those items more prominent.  Other minor improvements per
advice from Vitaly Burovoy, Masahiko Sawada, Peter Geoghegan,
and Andres Freund.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/306ff0aaf8ef2a4c69a799faf7e6c72fea1c4709

Modified Files
--
doc/src/sgml/release-9.6.sgml | 234 ++
1 file changed, 125 insertions(+), 109 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update time zone data files to tzdata release 2016d.

2016-05-05 Thread Tom Lane
Update time zone data files to tzdata release 2016d.

DST law changes in Russia (Magadan, Tomsk regions) and Venezuela.
Historical corrections for Russia.  There are new zone names Europe/Kirov
and Asia/Tomsk reflecting the fact that these regions now have different
time zone histories from adjacent regions.

Branch
--
REL9_2_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/29d154e3687bc27d89ca88a9f184ce4f436b25bd

Modified Files
--
src/timezone/data/asia | 286 +++--
src/timezone/data/europe   |  98 --
src/timezone/data/northamerica |  12 ++
src/timezone/data/southamerica |  18 ++-
src/timezone/data/zone.tab |   8 +-
src/timezone/data/zone1970.tab |   8 +-
src/timezone/known_abbrevs.txt |  37 +-
src/timezone/tznames/Asia.txt  |  12 +-
src/timezone/tznames/Default   |   3 +-
9 files changed, 349 insertions(+), 133 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update time zone data files to tzdata release 2016d.

2016-05-05 Thread Tom Lane
Update time zone data files to tzdata release 2016d.

DST law changes in Russia (Magadan, Tomsk regions) and Venezuela.
Historical corrections for Russia.  There are new zone names Europe/Kirov
and Asia/Tomsk reflecting the fact that these regions now have different
time zone histories from adjacent regions.

Branch
--
REL9_4_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/a5148e80003b6c932aea882687ed8ded3921b332

Modified Files
--
src/timezone/data/asia | 286 +++--
src/timezone/data/europe   |  98 --
src/timezone/data/northamerica |  12 ++
src/timezone/data/southamerica |  18 ++-
src/timezone/data/zone.tab |   8 +-
src/timezone/data/zone1970.tab |   8 +-
src/timezone/known_abbrevs.txt |  37 +-
src/timezone/tznames/Asia.txt  |  12 +-
src/timezone/tznames/Default   |   3 +-
9 files changed, 349 insertions(+), 133 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update time zone data files to tzdata release 2016d.

2016-05-05 Thread Tom Lane
Update time zone data files to tzdata release 2016d.

DST law changes in Russia (Magadan, Tomsk regions) and Venezuela.
Historical corrections for Russia.  There are new zone names Europe/Kirov
and Asia/Tomsk reflecting the fact that these regions now have different
time zone histories from adjacent regions.

Branch
--
REL9_5_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/4edbb265cee0b468d444b4aabb1b236334f09c3a

Modified Files
--
src/timezone/data/asia | 286 +++--
src/timezone/data/europe   |  98 --
src/timezone/data/northamerica |  12 ++
src/timezone/data/southamerica |  18 ++-
src/timezone/data/zone.tab |   8 +-
src/timezone/data/zone1970.tab |   8 +-
src/timezone/known_abbrevs.txt |  37 +-
src/timezone/tznames/Asia.txt  |  12 +-
src/timezone/tznames/Default   |   3 +-
9 files changed, 349 insertions(+), 133 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update time zone data files to tzdata release 2016d.

2016-05-05 Thread Tom Lane
Update time zone data files to tzdata release 2016d.

DST law changes in Russia (Magadan, Tomsk regions) and Venezuela.
Historical corrections for Russia.  There are new zone names Europe/Kirov
and Asia/Tomsk reflecting the fact that these regions now have different
time zone histories from adjacent regions.

Branch
--
REL9_3_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/d30c67af801dd4d380657d24a3211cfd4e0c4823

Modified Files
--
src/timezone/data/asia | 286 +++--
src/timezone/data/europe   |  98 --
src/timezone/data/northamerica |  12 ++
src/timezone/data/southamerica |  18 ++-
src/timezone/data/zone.tab |   8 +-
src/timezone/data/zone1970.tab |   8 +-
src/timezone/known_abbrevs.txt |  37 +-
src/timezone/tznames/Asia.txt  |  12 +-
src/timezone/tznames/Default   |   3 +-
9 files changed, 349 insertions(+), 133 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update time zone data files to tzdata release 2016d.

2016-05-05 Thread Tom Lane
Update time zone data files to tzdata release 2016d.

DST law changes in Russia (Magadan, Tomsk regions) and Venezuela.
Historical corrections for Russia.  There are new zone names Europe/Kirov
and Asia/Tomsk reflecting the fact that these regions now have different
time zone histories from adjacent regions.

Branch
--
REL9_1_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/bfc39da640310b81d81cc7a03bc778d959624a1f

Modified Files
--
src/timezone/data/asia | 286 +++--
src/timezone/data/europe   |  98 --
src/timezone/data/northamerica |  12 ++
src/timezone/data/southamerica |  18 ++-
src/timezone/data/zone.tab |   8 +-
src/timezone/data/zone1970.tab |   8 +-
src/timezone/known_abbrevs.txt |  37 +-
src/timezone/tznames/Asia.txt  |  12 +-
src/timezone/tznames/Default   |   3 +-
9 files changed, 349 insertions(+), 133 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update time zone data files to tzdata release 2016d.

2016-05-05 Thread Tom Lane
Update time zone data files to tzdata release 2016d.

DST law changes in Russia (Magadan, Tomsk regions) and Venezuela.
Historical corrections for Russia.  There are new zone names Europe/Kirov
and Asia/Tomsk reflecting the fact that these regions now have different
time zone histories from adjacent regions.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/98f158e41e8eea69c796d6734a3548ee62bb98ac

Modified Files
--
src/timezone/data/asia | 286 +++--
src/timezone/data/europe   |  98 --
src/timezone/data/northamerica |  12 ++
src/timezone/data/southamerica |  18 ++-
src/timezone/data/zone.tab |   8 +-
src/timezone/data/zone1970.tab |   8 +-
src/timezone/known_abbrevs.txt |  37 +-
src/timezone/tznames/Asia.txt  |  12 +-
src/timezone/tznames/Default   |   3 +-
9 files changed, 349 insertions(+), 133 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Rename tsvector delete() to ts_delete(), and filter() to ts_filt

2016-05-05 Thread Tom Lane
Rename tsvector delete() to ts_delete(), and filter() to ts_filter().

The similarity of the original names to SQL keywords seems like a bad
idea.  Rename them before we're stuck with 'em forever.

In passing, minor code and docs cleanup.

Discussion: <4875.1462210...@sss.pgh.pa.us>

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/0b9a23443283f9ffb17a39c25f74adefdb72cae1

Modified Files
--
doc/src/sgml/func.sgml| 132 +-
doc/src/sgml/textsearch.sgml  |   3 +-
src/backend/utils/adt/tsvector_op.c   |  17 ++---
src/include/catalog/catversion.h  |   2 +-
src/include/catalog/pg_proc.h |  12 ++--
src/test/regress/expected/tstypes.out |  58 +++
src/test/regress/sql/tstypes.sql  |  32 -
7 files changed, 128 insertions(+), 128 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Small 9.6 release note improvements.

2016-05-05 Thread Tom Lane
Small 9.6 release note improvements.

Sync release notes through today, and incorporate some suggestions
from Robert Haas.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/2f38b986fa8ff048c7226f1ca212e12084c715cf

Modified Files
--
doc/src/sgml/release-9.6.sgml | 69 +++
1 file changed, 43 insertions(+), 26 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Rename pgbench min/max to least/greatest, and fix handling of do

2016-05-05 Thread Tom Lane
Rename pgbench min/max to least/greatest, and fix handling of double args.

These functions behave like the backend's least/greatest functions,
not like min/max, so the originally-chosen names invite confusion.
Per discussion, rename to least/greatest.

I also took it upon myself to make them return double if any input is
double.  The previous behavior of silently coercing all inputs to int
surely does not meet the principle of least astonishment.

Copy-edit some of the other new functions' documentation, too.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/7a622b2731db5d0f6db8a3d0af88177f96d1cb2e

Modified Files
--
doc/src/sgml/ref/pgbench.sgml | 25 +
src/bin/pgbench/exprparse.y   |  8 +++---
src/bin/pgbench/pgbench.c | 64 ---
src/bin/pgbench/pgbench.h |  4 +--
4 files changed, 67 insertions(+), 34 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: First-draft release notes for Postgres 9.6.

2016-05-05 Thread Tom Lane
First-draft release notes for Postgres 9.6.

These are just of beta quality, but we're only at beta ... the section
about parallel query, in particular, could doubtless use more work.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/c311f7887376f7f3ce24c4c0dac4f9cb6ad3bee3

Modified Files
--
doc/src/sgml/catalogs.sgml|4 +-
doc/src/sgml/config.sgml  |   44 +-
doc/src/sgml/filelist.sgml|1 +
doc/src/sgml/monitoring.sgml  |6 +-
doc/src/sgml/release-9.6.sgml | 3260 +
doc/src/sgml/release.sgml |1 +
6 files changed, 3289 insertions(+), 27 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix ordering/categorization of some recently-added system views.

2016-05-05 Thread Tom Lane
Fix ordering/categorization of some recently-added system views.

Somebody added pg_replication_origin, pg_replication_origin_status and
pg_replication_slots to catalogs.sgml without a whole lot of concern for
either alphabetical order or the difference between a table and a view.
Clean up the mess.

Back-patch to 9.5, not so much because this is critical as because if
I don't it will result in a cross-branch divergence in release-9.5.sgml,
which would be a maintenance hazard.

Branch
--
REL9_5_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/e4a58520fc3328455b46cf9bf589904133faa016

Modified Files
--
doc/src/sgml/catalogs.sgml| 494 +-
doc/src/sgml/high-availability.sgml   |   2 +-
doc/src/sgml/logicaldecoding.sgml |   2 +-
doc/src/sgml/release-9.5.sgml |   2 +-
doc/src/sgml/replication-origins.sgml |   2 +-
5 files changed, 251 insertions(+), 251 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix ordering/categorization of some recently-added system views.

2016-05-05 Thread Tom Lane
Fix ordering/categorization of some recently-added system views.

Somebody added pg_replication_origin, pg_replication_origin_status and
pg_replication_slots to catalogs.sgml without a whole lot of concern for
either alphabetical order or the difference between a table and a view.
Clean up the mess.

Back-patch to 9.5, not so much because this is critical as because if
I don't it will result in a cross-branch divergence in release-9.5.sgml,
which would be a maintenance hazard.

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/a9ba6195f12d9b89e103c1b043cc6958e40b1ef0

Modified Files
--
doc/src/sgml/catalogs.sgml| 515 +-
doc/src/sgml/high-availability.sgml   |   2 +-
doc/src/sgml/logicaldecoding.sgml |   2 +-
doc/src/sgml/release-9.5.sgml |   2 +-
doc/src/sgml/replication-origins.sgml |   2 +-
5 files changed, 261 insertions(+), 262 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix corner-case loss of precision in numeric pow() calculation

2016-05-05 Thread Dean Rasheed
Fix corner-case loss of precision in numeric pow() calculation

Commit 7d9a4737c268f61fb8800957631f12d3f13be218 greatly improved the
accuracy of the numeric transcendental functions, however it failed to
consider the case where the result from pow() is close to the overflow
threshold, for example 0.12 ^ -2345.6. For such inputs, where the
result has more than 2000 digits before the decimal point, the decimal
result weight estimate was being clamped to 2000, leading to a loss of
precision in the final calculation.

Fix this by replacing the clamping code with an overflow test that
aborts the calculation early if the final result is sure to overflow,
based on the overflow limit in exp_var(). This provides the same
protection against integer overflow in the subsequent result scale
computation as the original clamping code, but it also ensures that
precision is never lost and saves compute cycles in cases that are
sure to overflow.

The new early overflow test works with the initial low-precision
result (expected to be accurate to around 8 significant digits) and
includes a small fuzz factor to ensure that it doesn't kick in for
values that would not overflow exp_var(), so the overall overflow
threshold of pow() is unchanged and consistent for all inputs with
non-integer exponents.

Author: Dean Rasheed
Reviewed-by: Tom Lane
Discussion: 
http://www.postgresql.org/message-id/CAEZATCUj3U-cQj0jjoia=qgs0sje3auroxh8swvnkvzwuqe...@mail.gmail.com
See-also: 
http://www.postgresql.org/message-id/CAEZATCV7w+8iB=07dj8q0zihxqt1semcqutek+4_rogc_zq...@mail.gmail.com

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/18a02ad2a506e4425c6dd2ea235039cd5659467d

Modified Files
--
src/backend/utils/adt/numeric.c   | 20 
src/test/regress/expected/numeric_big.out | 14 ++
src/test/regress/sql/numeric_big.sql  | 10 ++
3 files changed, 40 insertions(+), 4 deletions(-)


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers