[COMMITTERS] pgsql: Add PQencryptPasswordConn function to libpq, use it in psql and

2017-05-03 Thread Heikki Linnakangas
Add PQencryptPasswordConn function to libpq, use it in psql and createuser. The new function supports creating SCRAM verifiers, in addition to md5 hashes. The algorithm is chosen based on password_encryption, by default. This fixes the issue reported by Jeff Janes, that there was previously no wa

[COMMITTERS] pgsql: pg_dump/t/002: append terminating semicolon to SQL commands

2017-05-03 Thread Alvaro Herrera
pg_dump/t/002: append terminating semicolon to SQL commands It's easy to overlook the need for one, and its lack is annoying for the next developer wanting to create a new test. Rather than expect every individual command to add the semicolon, just append one automatically. Discussion: http://po

[COMMITTERS] pgsql: Add pg_dump tests for CREATE STATISTICS

2017-05-03 Thread Alvaro Herrera
Add pg_dump tests for CREATE STATISTICS CREATE STATISTICS pg_dump support code was not covered at all by previous tests. Discussion: https://postgr.es/m/20170503172746.rwftidszir67sgk7@alvherre.pgsql Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/a93077ef467138235

[COMMITTERS] pgsql: Remove useless and rather expensive stanza in matview regression

2017-05-03 Thread Tom Lane
Remove useless and rather expensive stanza in matview regression test. This removes a test case added by commit b69ec7cc9, which was intended to exercise a corner case involving the rule used at that time that materialized views were unpopulated iff they had physical size zero. We got rid of that

[COMMITTERS] pgsql: Remove useless and rather expensive stanza in matview regression

2017-05-03 Thread Tom Lane
Remove useless and rather expensive stanza in matview regression test. This removes a test case added by commit b69ec7cc9, which was intended to exercise a corner case involving the rule used at that time that materialized views were unpopulated iff they had physical size zero. We got rid of that

[COMMITTERS] pgsql: Remove useless and rather expensive stanza in matview regression

2017-05-03 Thread Tom Lane
Remove useless and rather expensive stanza in matview regression test. This removes a test case added by commit b69ec7cc9, which was intended to exercise a corner case involving the rule used at that time that materialized views were unpopulated iff they had physical size zero. We got rid of that

[COMMITTERS] pgsql: Remove useless and rather expensive stanza in matview regression

2017-05-03 Thread Tom Lane
Remove useless and rather expensive stanza in matview regression test. This removes a test case added by commit b69ec7cc9, which was intended to exercise a corner case involving the rule used at that time that materialized views were unpopulated iff they had physical size zero. We got rid of that

[COMMITTERS] pgsql: Remove useless and rather expensive stanza in matview regression

2017-05-03 Thread Tom Lane
Remove useless and rather expensive stanza in matview regression test. This removes a test case added by commit b69ec7cc9, which was intended to exercise a corner case involving the rule used at that time that materialized views were unpopulated iff they had physical size zero. We got rid of that

[COMMITTERS] pgsql: Fix cursor_to_xml in tableforest false mode

2017-05-03 Thread Peter Eisentraut
Fix cursor_to_xml in tableforest false mode It only produced elements but no wrapping element. By contrast, cursor_to_xmlschema produced a schema that is now correct but did not previously match the XML data produced by cursor_to_xml. In passing, also fix a minor misunderstanding about moving