[COMMITTERS] pgsql: pg_stat_statements: Add .gitignore file for tests

2016-11-13 Thread Peter Eisentraut
pg_stat_statements: Add .gitignore file for tests

Branch
--
master

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

Modified Files
--
contrib/pg_stat_statements/.gitignore | 4 
1 file changed, 4 insertions(+)


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


[COMMITTERS] pgsql: Doc: remove obsolete example.

2016-11-13 Thread Tom Lane
Doc: remove obsolete example.

The documentation for ts_headline() recommends using a sub-select to
avoid extra evaluations of ts_headline() in a query with ORDER BY+LIMIT.
Since commit 9118d03a8 this contortionism is unnecessary, so remove the
recommendation.  Noted by Oleg Bartunov.

Discussion: 

Branch
--
REL9_6_STABLE

Details
---
http://git.postgresql.org/pg/commitdiff/6f932cac7a20995e07d8c546143c45793a5072a0

Modified Files
--
doc/src/sgml/textsearch.sgml | 14 +-
1 file changed, 1 insertion(+), 13 deletions(-)


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


[COMMITTERS] pgsql: Doc: remove obsolete example.

2016-11-13 Thread Tom Lane
Doc: remove obsolete example.

The documentation for ts_headline() recommends using a sub-select to
avoid extra evaluations of ts_headline() in a query with ORDER BY+LIMIT.
Since commit 9118d03a8 this contortionism is unnecessary, so remove the
recommendation.  Noted by Oleg Bartunov.

Discussion: 

Branch
--
master

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

Modified Files
--
doc/src/sgml/textsearch.sgml | 14 +-
1 file changed, 1 insertion(+), 13 deletions(-)


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


[COMMITTERS] pgsql: pg_upgrade: Upgrade sequence data via pg_dump

2016-11-13 Thread Peter Eisentraut
pg_upgrade: Upgrade sequence data via pg_dump

Previously, pg_upgrade migrated sequence data like tables by copying the
on-disk file.  This does not allow any changes in the on-disk format for
sequences.  It's simpler to just have pg_dump set the new sequence
values as it normally does.  To do that, create a hidden submode in
pg_dump that dumps sequence data even when a schema-only dump is
requested, and trigger that submode in binary upgrade mode.  (This new
submode could easily be exposed as a command-line option, but it has
limited use outside of pg_dump and would probably cause some confusion,
so we don't do that at this time.)

Reviewed-by: Anastasia Lubennikova 
Reviewed-by: Michael Paquier 

Branch
--
master

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

Modified Files
--
src/bin/pg_dump/pg_backup.h  |  3 +++
src/bin/pg_dump/pg_backup_archiver.c |  6 +-
src/bin/pg_dump/pg_dump.c| 19 +++
src/bin/pg_upgrade/info.c|  2 +-
4 files changed, 24 insertions(+), 6 deletions(-)


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


[COMMITTERS] pgsql: pg_dump: Separate table and sequence data object types

2016-11-13 Thread Peter Eisentraut
pg_dump: Separate table and sequence data object types

Instead of handling both sequence data and table data internally as
"table data", handle sequences separately under a "sequence set" type.
We already handled materialized view data differently, so it makes the
code somewhat cleaner to handle each relation kind separately at the top
level.

This does not change the output format, since there already was a
separate "SEQUENCE SET" archive entry type.  A noticeable difference is
that SEQUENCE SET entries now always appear after TABLE DATA entries.
And in parallel mode there is less sorting to do, because the sequence
data entries are no longer considered table data.

Reviewed-by: Anastasia Lubennikova 
Reviewed-by: Michael Paquier 

Branch
--
master

Details
---
http://git.postgresql.org/pg/commitdiff/27d2c1232879aab5636da56b698764d553b9c5c6

Modified Files
--
src/bin/pg_dump/pg_dump.c  | 11 +++
src/bin/pg_dump/pg_dump.h  |  1 +
src/bin/pg_dump/pg_dump_sort.c | 28 +---
3 files changed, 25 insertions(+), 15 deletions(-)


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