[COMMITTERS] pgsql: Refactor sendAuthRequest.

2016-08-18 Thread Heikki Linnakangas
Refactor sendAuthRequest. This way sendAuthRequest doesn't need to know the details of all the different authentication methods. This is in preparation for adding SCRAM authentication, which will add yet another authentication request message type, with different payload. Reviewed-By: Michael Paq

[COMMITTERS] pgsql: Update Windows timezone mapping from Windows 7 and 10

2016-08-18 Thread Magnus Hagander
Update Windows timezone mapping from Windows 7 and 10 This adds a couple of new timezones that are present in the newer versions of Windows. It also updates comments to reference UTC rather than GMT, as this change has been made in Windows. Michael Paquier Branch -- REL9_6_STABLE Details --

[COMMITTERS] pgsql: Update Windows timezone mapping from Windows 7 and 10

2016-08-18 Thread Magnus Hagander
Update Windows timezone mapping from Windows 7 and 10 This adds a couple of new timezones that are present in the newer versions of Windows. It also updates comments to reference UTC rather than GMT, as this change has been made in Windows. Michael Paquier Branch -- master Details --- h

[COMMITTERS] pgsql: Refactor RandomSalt to handle salts of different lengths.

2016-08-18 Thread Heikki Linnakangas
Refactor RandomSalt to handle salts of different lengths. All we need is 4 bytes at the moment, for MD5 authentication. But in upcomint patches for SCRAM authentication, SCRAM will need a salt of different length. It's less scary for the caller to pass the buffer length anyway, than assume a certa

[COMMITTERS] pgsql: Improve formatting of comments in plpgsql.h

2016-08-18 Thread Peter Eisentraut
Improve formatting of comments in plpgsql.h This file had some unusual comment layout. Most of the comments introducing structs ended up to the right of the screen and following the start of the struct. Some comments for struct members ended up after the member definition. Fix that by moving co

[COMMITTERS] pgsql: Update Windows timezone mapping from Windows 7 and 10

2016-08-18 Thread Magnus Hagander
Update Windows timezone mapping from Windows 7 and 10 This adds a couple of new timezones that are present in the newer versions of Windows. It also updates comments to reference UTC rather than GMT, as this change has been made in Windows. Michael Paquier Branch -- REL9_3_STABLE Details --

[COMMITTERS] pgsql: Update Windows timezone mapping from Windows 7 and 10

2016-08-18 Thread Magnus Hagander
Update Windows timezone mapping from Windows 7 and 10 This adds a couple of new timezones that are present in the newer versions of Windows. It also updates comments to reference UTC rather than GMT, as this change has been made in Windows. Michael Paquier Branch -- REL9_4_STABLE Details --

[COMMITTERS] pgsql: Update Windows timezone mapping from Windows 7 and 10

2016-08-18 Thread Magnus Hagander
Update Windows timezone mapping from Windows 7 and 10 This adds a couple of new timezones that are present in the newer versions of Windows. It also updates comments to reference UTC rather than GMT, as this change has been made in Windows. Michael Paquier Branch -- REL9_2_STABLE Details --

[COMMITTERS] pgsql: Update Windows timezone mapping from Windows 7 and 10

2016-08-18 Thread Magnus Hagander
Update Windows timezone mapping from Windows 7 and 10 This adds a couple of new timezones that are present in the newer versions of Windows. It also updates comments to reference UTC rather than GMT, as this change has been made in Windows. Michael Paquier Branch -- REL9_5_STABLE Details --

[COMMITTERS] pgsql: Support the new regexp_match() function for citext.

2016-08-18 Thread Tom Lane
Support the new regexp_match() function for citext. Emre Hasegeli Patch: Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f9d747a4e908ad09520cad4c0e8c915074e9964c Modified Files -- contrib/citext/Makefile | 3 +- contrib/citext/citext--1.3

[COMMITTERS] pgsql: Improve psql's tab completion for ALTER EXTENSION foo UPDATE ...

2016-08-18 Thread Tom Lane
Improve psql's tab completion for ALTER EXTENSION foo UPDATE ... Offer a list of available versions for that extension. Formerly, since there was no special support for this, it triggered off the UPDATE keyword and offered a list of table names --- not too helpful. Jeff Janes, reviewed by Gerdan

[COMMITTERS] pgsql: Improve psql's tab completion for \l.

2016-08-18 Thread Tom Lane
Improve psql's tab completion for \l. Offer a list of database names; formerly no help was offered. Ian Barwick, reviewed by Gerdan Santos Patch: <5724132e.1030...@2ndquadrant.com> Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8019b5a89c3cefbaa69ab58c00281419f7e4

[COMMITTERS] pgsql: doc: Speed up XSLT builds

2016-08-18 Thread Peter Eisentraut
doc: Speed up XSLT builds The upstream XSLT stylesheets use some very general XPath expressions in some places that end up being very slow. We can optimize them with knowledge about the DocBook document structure and our particular use thereof. For example, when counting preceding chapters to ge

[COMMITTERS] pgsql: In plpgsql, don't try to convert int2vector or oidvector to expa

2016-08-18 Thread Tom Lane
In plpgsql, don't try to convert int2vector or oidvector to expanded array. These types are storage-compatible with real arrays, but they don't support toasting, so of course they can't support expansion either. Per bug #14289 from Michael Overmeyer. Back-patch to 9.5 where expanded arrays were

[COMMITTERS] pgsql: In plpgsql, don't try to convert int2vector or oidvector to expa

2016-08-18 Thread Tom Lane
In plpgsql, don't try to convert int2vector or oidvector to expanded array. These types are storage-compatible with real arrays, but they don't support toasting, so of course they can't support expansion either. Per bug #14289 from Michael Overmeyer. Back-patch to 9.5 where expanded arrays were

[COMMITTERS] pgsql: In plpgsql, don't try to convert int2vector or oidvector to expa

2016-08-18 Thread Tom Lane
In plpgsql, don't try to convert int2vector or oidvector to expanded array. These types are storage-compatible with real arrays, but they don't support toasting, so of course they can't support expansion either. Per bug #14289 from Michael Overmeyer. Back-patch to 9.5 where expanded arrays were

[COMMITTERS] pgsql: Update line count totals for psql help displays.

2016-08-18 Thread Tom Lane
Update line count totals for psql help displays. As usual, we've been pretty awful about maintaining these counts. They're not all that critical, perhaps, but let's get them right at release time. Also fix 9.5, which I notice is just as bad. It's probably wrong further back, but the lack of --hel

[COMMITTERS] pgsql: Update line count totals for psql help displays.

2016-08-18 Thread Tom Lane
Update line count totals for psql help displays. As usual, we've been pretty awful about maintaining these counts. They're not all that critical, perhaps, but let's get them right at release time. Also fix 9.5, which I notice is just as bad. It's probably wrong further back, but the lack of --hel

[COMMITTERS] pgsql: Update line count totals for psql help displays.

2016-08-18 Thread Tom Lane
Update line count totals for psql help displays. As usual, we've been pretty awful about maintaining these counts. They're not all that critical, perhaps, but let's get them right at release time. Also fix 9.5, which I notice is just as bad. It's probably wrong further back, but the lack of --hel

[COMMITTERS] pgsql: Remove obsolete replacement system() on darwin

2016-08-18 Thread Peter Eisentraut
Remove obsolete replacement system() on darwin Per comment in the file, this was fixed around OS X 10.2. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1d2e73a3dfdbd7168b323fa39879c60df6076412 Modified Files -- src/backend/port/Makefile| 4 --

[COMMITTERS] pgsql: Add alternative output for ON CONFLICT toast isolation test.

2016-08-18 Thread Andres Freund
Add alternative output for ON CONFLICT toast isolation test. On some buildfarm animals the isolationtest added in 07ef0351 failed, as the order in which processes are run after unlocking is not guaranteed. Add an alternative output for that. Discussion: <7969.1471484...@sss.pgh.pa.us> Backpatch:

[COMMITTERS] pgsql: Add alternative output for ON CONFLICT toast isolation test.

2016-08-18 Thread Andres Freund
Add alternative output for ON CONFLICT toast isolation test. On some buildfarm animals the isolationtest added in 07ef0351 failed, as the order in which processes are run after unlocking is not guaranteed. Add an alternative output for that. Discussion: <7969.1471484...@sss.pgh.pa.us> Backpatch:

[COMMITTERS] pgsql: doc: requirepeer is a way to avoid spoofing

2016-08-18 Thread Bruce Momjian
doc: requirepeer is a way to avoid spoofing We already mentioned unix_socket_directories as an option. Reported-by: https://www.postgresql.org/message-id/45016837-6cf3-3136-f959-763d06a28076%402ndquadrant.com Backpatch-through: 9.6 Branch -- REL9_6_STABLE Details --- http://git.postg

[COMMITTERS] pgsql: doc: requirepeer is a way to avoid spoofing

2016-08-18 Thread Bruce Momjian
doc: requirepeer is a way to avoid spoofing We already mentioned unix_socket_directories as an option. Reported-by: https://www.postgresql.org/message-id/45016837-6cf3-3136-f959-763d06a28076%402ndquadrant.com Backpatch-through: 9.6 Branch -- master Details --- http://git.postgresql.o