[COMMITTERS] pgsql: On Windows, make pg_dump use binary mode for compressed plain te

2017-06-19 Thread Tom Lane
On Windows, make pg_dump use binary mode for compressed plain text output. The combination of -Z -Fp and output to stdout resulted in corrupted output data, because we left stdout in text mode, resulting in newline conversion being done on the compressed stream. Switch stdout to binary mode for t

[COMMITTERS] pgsql: On Windows, make pg_dump use binary mode for compressed plain te

2017-06-19 Thread Tom Lane
On Windows, make pg_dump use binary mode for compressed plain text output. The combination of -Z -Fp and output to stdout resulted in corrupted output data, because we left stdout in text mode, resulting in newline conversion being done on the compressed stream. Switch stdout to binary mode for t

[COMMITTERS] pgsql: On Windows, make pg_dump use binary mode for compressed plain te

2017-06-19 Thread Tom Lane
On Windows, make pg_dump use binary mode for compressed plain text output. The combination of -Z -Fp and output to stdout resulted in corrupted output data, because we left stdout in text mode, resulting in newline conversion being done on the compressed stream. Switch stdout to binary mode for t

[COMMITTERS] pgsql: On Windows, make pg_dump use binary mode for compressed plain te

2017-06-19 Thread Tom Lane
On Windows, make pg_dump use binary mode for compressed plain text output. The combination of -Z -Fp and output to stdout resulted in corrupted output data, because we left stdout in text mode, resulting in newline conversion being done on the compressed stream. Switch stdout to binary mode for t

[COMMITTERS] pgsql: On Windows, make pg_dump use binary mode for compressed plain te

2017-06-19 Thread Tom Lane
On Windows, make pg_dump use binary mode for compressed plain text output. The combination of -Z -Fp and output to stdout resulted in corrupted output data, because we left stdout in text mode, resulting in newline conversion being done on the compressed stream. Switch stdout to binary mode for t

[COMMITTERS] pgsql: On Windows, make pg_dump use binary mode for compressed plain te

2017-06-19 Thread Tom Lane
On Windows, make pg_dump use binary mode for compressed plain text output. The combination of -Z -Fp and output to stdout resulted in corrupted output data, because we left stdout in text mode, resulting in newline conversion being done on the compressed stream. Switch stdout to binary mode for t

[COMMITTERS] pgsql: Avoid regressions in foreign-key-based selectivity estimates.

2017-06-19 Thread Tom Lane
Avoid regressions in foreign-key-based selectivity estimates. David Rowley found that the "use the smallest per-column selectivity" heuristic applied in some cases by get_foreign_key_join_selectivity() was badly off if the FK columns are independent, producing estimates much worse than we got befo

[COMMITTERS] pgsql: Avoid regressions in foreign-key-based selectivity estimates.

2017-06-19 Thread Tom Lane
Avoid regressions in foreign-key-based selectivity estimates. David Rowley found that the "use the smallest per-column selectivity" heuristic applied in some cases by get_foreign_key_join_selectivity() was badly off if the FK columns are independent, producing estimates much worse than we got befo

[COMMITTERS] pgsql: doc: Improve logical replication security setup info

2017-06-19 Thread Peter Eisentraut
doc: Improve logical replication security setup info Reported-by: Jeff Janes Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1c25ef6363f38253e5ac080373eef7f3305fa5dc Modified Files -- doc/src/sgml/logical-replication.sgml | 2 +- doc/src/sgml/ref/cr

[COMMITTERS] pgsql: Fix materialized-view documentation oversights.

2017-06-19 Thread Tom Lane
Fix materialized-view documentation oversights. When materialized views were added, psql's \d commands were made to treat them as a separate object category ... but not everyplace in the documentation or comments got the memo. Noted by David Johnston. Back-patch to 9.3 where matviews came in. D

[COMMITTERS] pgsql: Fix materialized-view documentation oversights.

2017-06-19 Thread Tom Lane
Fix materialized-view documentation oversights. When materialized views were added, psql's \d commands were made to treat them as a separate object category ... but not everyplace in the documentation or comments got the memo. Noted by David Johnston. Back-patch to 9.3 where matviews came in. D

[COMMITTERS] pgsql: Fix materialized-view documentation oversights.

2017-06-19 Thread Tom Lane
Fix materialized-view documentation oversights. When materialized views were added, psql's \d commands were made to treat them as a separate object category ... but not everyplace in the documentation or comments got the memo. Noted by David Johnston. Back-patch to 9.3 where matviews came in. D

[COMMITTERS] pgsql: Fix materialized-view documentation oversights.

2017-06-19 Thread Tom Lane
Fix materialized-view documentation oversights. When materialized views were added, psql's \d commands were made to treat them as a separate object category ... but not everyplace in the documentation or comments got the memo. Noted by David Johnston. Back-patch to 9.3 where matviews came in. D

[COMMITTERS] pgsql: Fix materialized-view documentation oversights.

2017-06-19 Thread Tom Lane
Fix materialized-view documentation oversights. When materialized views were added, psql's \d commands were made to treat them as a separate object category ... but not everyplace in the documentation or comments got the memo. Noted by David Johnston. Back-patch to 9.3 where matviews came in. D