[COMMITTERS] pgsql: Simplify some long-obsolete code in hba.c's next_token().

2017-01-30 Thread Tom Lane
Simplify some long-obsolete code in hba.c's next_token(). next_token() oddly set its buffer space consumption limit to one before the last char position in the buffer, not the last as you'd expect. The reason is there was once an ugly kluge to mark keywords by appending a newline to them, potentia

[COMMITTERS] pgsql: Invent pg_hba_file_rules view to show the content of pg_hba.conf

2017-01-30 Thread Tom Lane
Invent pg_hba_file_rules view to show the content of pg_hba.conf. This view is designed along the same lines as pg_file_settings, to wit it shows what is currently in the file, not what the postmaster has loaded as the active settings. That allows it to be used to pre-vet edits before issuing SIG

[COMMITTERS] pgsql: Add a regression test script dedicated to exercising system view

2017-01-30 Thread Tom Lane
Add a regression test script dedicated to exercising system views. Quite a few of our built-in system views were not exercised anywhere in the regression tests. This is perhaps not so exciting for the ones that are simple projections/joins of system catalogs, but for the ones that are wrappers fo

[COMMITTERS] pgsql: Make psql reject attempts to set special variables to invalid va

2017-01-30 Thread Tom Lane
Make psql reject attempts to set special variables to invalid values. Previously, if the user set a special variable such as ECHO to an unrecognized value, psql would bleat but store the new value anyway, and then fall back to a default setting for the behavior controlled by the variable. This wa

[COMMITTERS] pgsql: Fix sequence test in cs_CZ locale

2017-01-30 Thread Peter Eisentraut
Fix sequence test in cs_CZ locale Rename some objects so that sorted output becomes less locale-dependent. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/46aae5949f56580281a0f487c785c745d8856a04 Modified Files -- src/test/regress/expected/sequence.out |

Re: [COMMITTERS] pgsql: test_pg_dump TAP test whitespace cleanup

2017-01-30 Thread Alvaro Herrera
Stephen Frost wrote: > * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > > This will be undone by the next perltidy run. > > Ugh. > > I certainly hope what was there before wasn't the result of a perltidy > run as it was quite ugly and inconsistent.. Maybe it was. I checked the diff after r

[COMMITTERS] pgsql: Additional test coverage for sequences

2017-01-30 Thread Peter Eisentraut
Additional test coverage for sequences Reviewed-by: Michael Paquier Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d711532b2eb70cf2f56d95efcc608d474266d769 Modified Files -- src/test/regress/expected/sequence.out | 253 +

Re: [COMMITTERS] pgsql: test_pg_dump TAP test whitespace cleanup

2017-01-30 Thread Stephen Frost
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > Stephen Frost wrote: > > test_pg_dump TAP test whitespace cleanup > > > > The formatting of the perl hashes used in the TAP tests for test_pg_dump > > was rather horribly inconsistent and made it more difficult than it > > really should have bee

Re: [COMMITTERS] pgsql: test_pg_dump TAP test whitespace cleanup

2017-01-30 Thread Alvaro Herrera
Stephen Frost wrote: > test_pg_dump TAP test whitespace cleanup > > The formatting of the perl hashes used in the TAP tests for test_pg_dump > was rather horribly inconsistent and made it more difficult than it > really should have been to add new tests or adjust what tests are for > what runs, et

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

2017-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2016j. DST law changes in northern Cyprus (new zone Asia/Famagusta), Russia (new zone Europe/Saratov), Tonga, Antarctica/Casey. Historical corrections for Asia/Aqtau, Asia/Atyrau, Asia/Gaza, Asia/Hebron, Italy, Malta. Replace invented zone abbreviati

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

2017-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2016j. DST law changes in northern Cyprus (new zone Asia/Famagusta), Russia (new zone Europe/Saratov), Tonga, Antarctica/Casey. Historical corrections for Asia/Aqtau, Asia/Atyrau, Asia/Gaza, Asia/Hebron, Italy, Malta. Replace invented zone abbreviati

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

2017-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2016j. DST law changes in northern Cyprus (new zone Asia/Famagusta), Russia (new zone Europe/Saratov), Tonga, Antarctica/Casey. Historical corrections for Asia/Aqtau, Asia/Atyrau, Asia/Gaza, Asia/Hebron, Italy, Malta. Replace invented zone abbreviati

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

2017-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2016j. DST law changes in northern Cyprus (new zone Asia/Famagusta), Russia (new zone Europe/Saratov), Tonga, Antarctica/Casey. Historical corrections for Asia/Aqtau, Asia/Atyrau, Asia/Gaza, Asia/Hebron, Italy, Malta. Replace invented zone abbreviati

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

2017-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2016j. DST law changes in northern Cyprus (new zone Asia/Famagusta), Russia (new zone Europe/Saratov), Tonga, Antarctica/Casey. Historical corrections for Asia/Aqtau, Asia/Atyrau, Asia/Gaza, Asia/Hebron, Italy, Malta. Replace invented zone abbreviati

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

2017-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2016j. DST law changes in northern Cyprus (new zone Asia/Famagusta), Russia (new zone Europe/Saratov), Tonga, Antarctica/Casey. Historical corrections for Asia/Aqtau, Asia/Atyrau, Asia/Gaza, Asia/Hebron, Italy, Malta. Replace invented zone abbreviati

Re: [COMMITTERS] pgsql: Simplify tape block format.

2017-01-30 Thread Heikki Linnakangas
On 12/26/2016 11:52 PM, Peter Geoghegan wrote: On Thu, Dec 22, 2016 at 8:45 AM, Heikki Linnakangas wrote: Simplify tape block format. No more indirect blocks. The blocks form a linked list instead. There is still one remaining reference to indirect blocks that you missed in comments above Lo

[COMMITTERS] pgsql: Remove leftover reference to "indirect blocks" in comment.

2017-01-30 Thread Heikki Linnakangas
Remove leftover reference to "indirect blocks" in comment. Peter Geoghegan Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/dbeca61c3535af2613000c4492848ca6da8a902f Modified Files -- src/backend/utils/sort/logtape.c | 6 +++--- 1 file changed, 3 insertions