pgsql: MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T.

2017-12-08 Thread Noah Misch
MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T. Commits 5a5c2feca3fd858e70ea348822595547e6fa6c15 and b5178c5d08ca59e30f9d9428fa6fdb2741794e65 introduced support for modern MSVC-built, 32-bit Perl, but they broke use of MinGW-built, 32-bit Perl distributions like Strawberry Perl and moder

pgsql: MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T.

2017-12-08 Thread Noah Misch
MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T. Commits 5a5c2feca3fd858e70ea348822595547e6fa6c15 and b5178c5d08ca59e30f9d9428fa6fdb2741794e65 introduced support for modern MSVC-built, 32-bit Perl, but they broke use of MinGW-built, 32-bit Perl distributions like Strawberry Perl and moder

pgsql: MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T.

2017-12-08 Thread Noah Misch
MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T. Commits 5a5c2feca3fd858e70ea348822595547e6fa6c15 and b5178c5d08ca59e30f9d9428fa6fdb2741794e65 introduced support for modern MSVC-built, 32-bit Perl, but they broke use of MinGW-built, 32-bit Perl distributions like Strawberry Perl and moder

pgsql: MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T.

2017-12-08 Thread Noah Misch
MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T. Commits 5a5c2feca3fd858e70ea348822595547e6fa6c15 and b5178c5d08ca59e30f9d9428fa6fdb2741794e65 introduced support for modern MSVC-built, 32-bit Perl, but they broke use of MinGW-built, 32-bit Perl distributions like Strawberry Perl and moder

pgsql: MSVC: Remove cosmetic, cross-branch differences pertaining to Pe

2017-12-08 Thread Noah Misch
MSVC: Remove cosmetic, cross-branch differences pertaining to Perl. This simplifies back-patch of the next change to v9.5 and v9.6. Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/85a83a3cc69f72fa779eceea400b44efd7c26fa7 Modified Files -- src/too

pgsql: MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T.

2017-12-08 Thread Noah Misch
MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T. Commits 5a5c2feca3fd858e70ea348822595547e6fa6c15 and b5178c5d08ca59e30f9d9428fa6fdb2741794e65 introduced support for modern MSVC-built, 32-bit Perl, but they broke use of MinGW-built, 32-bit Perl distributions like Strawberry Perl and moder

pgsql: MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T.

2017-12-08 Thread Noah Misch
MSVC: Test whether 32-bit Perl needs -D_USE_32BIT_TIME_T. Commits 5a5c2feca3fd858e70ea348822595547e6fa6c15 and b5178c5d08ca59e30f9d9428fa6fdb2741794e65 introduced support for modern MSVC-built, 32-bit Perl, but they broke use of MinGW-built, 32-bit Perl distributions like Strawberry Perl and moder

pgsql: MSVC: Remove cosmetic, cross-branch differences pertaining to Pe

2017-12-08 Thread Noah Misch
MSVC: Remove cosmetic, cross-branch differences pertaining to Perl. This simplifies back-patch of the next change to v9.5 and v9.6. Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a59b3428efa79a699b87355eb859877f205fb33d Modified Files -- src/too

pgsql: Prohibit identity columns on typed tables and partitions

2017-12-08 Thread Peter Eisentraut
Prohibit identity columns on typed tables and partitions Those cases currently crash and supporting them is more work then originally thought, so we'll just prohibit these scenarios for now. Author: Michael Paquier Reviewed-by: Amit Langote Reported-by: Мансур Галиев Bug: #14866 Branch --

pgsql: Prohibit identity columns on typed tables and partitions

2017-12-08 Thread Peter Eisentraut
Prohibit identity columns on typed tables and partitions Those cases currently crash and supporting them is more work then originally thought, so we'll just prohibit these scenarios for now. Author: Michael Paquier Reviewed-by: Amit Langote Reported-by: Мансур Галиев Bug: #14866 Branch --

pgsql: Fix mistake in comment

2017-12-08 Thread Peter Eisentraut
Fix mistake in comment Reported-by: Masahiko Sawada Branch -- REL9_3_STABLE Details --- https://git.postgresql.org/pg/commitdiff/99aa36df374231c1d86c9b899740890b54574cb9 Modified Files -- src/backend/access/transam/xlog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix mistake in comment

2017-12-08 Thread Peter Eisentraut
Fix mistake in comment Reported-by: Masahiko Sawada Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/af9f8b7ca343eefa33b693d7919d8f945aeee3e7 Modified Files -- src/backend/access/transam/xlog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix mistake in comment

2017-12-08 Thread Peter Eisentraut
Fix mistake in comment Reported-by: Masahiko Sawada Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/340a67a32d5a872a458d53acb604fc9fd2b5019a Modified Files -- src/backend/access/transam/xlog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix mistake in comment

2017-12-08 Thread Peter Eisentraut
Fix mistake in comment Reported-by: Masahiko Sawada Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7abb9dd6722876ccf495619711fa6052e2882a73 Modified Files -- src/backend/access/transam/xlog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix mistake in comment

2017-12-08 Thread Peter Eisentraut
Fix mistake in comment Reported-by: Masahiko Sawada Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8b33b5b9dfce9b7fb94b8996f4e0bac7e5bb6c21 Modified Files -- src/backend/access/transam/xlog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Fix mistake in comment

2017-12-08 Thread Peter Eisentraut
Fix mistake in comment Reported-by: Masahiko Sawada Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ba8cc0ad05b050471e50c8d20ea24466bade3ecc Modified Files -- src/backend/access/transam/xlog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: In plpgsql, unify duplicate variables for record and row cases.

2017-12-08 Thread Tom Lane
In plpgsql, unify duplicate variables for record and row cases. plpgsql's function exec_move_row() handles assignment of a composite source value to either a PLpgSQL_rec or PLpgSQL_row target variable. Oddly, rather than taking a single target argument which it could do run-time type detection on,

pgsql: doc: Add advice about systemd RemoveIPC

2017-12-08 Thread Peter Eisentraut
doc: Add advice about systemd RemoveIPC Reviewed-by: Magnus Hagander Branch -- REL9_3_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6a1459f67cd46a244f76d93a116be11bf7c92071 Modified Files -- doc/src/sgml/runtime.sgml | 79 ++

pgsql: doc: Add advice about systemd RemoveIPC

2017-12-08 Thread Peter Eisentraut
doc: Add advice about systemd RemoveIPC Reviewed-by: Magnus Hagander Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6605efb4c2bc7b0245fc7bc9b335c4fc566cfa73 Modified Files -- doc/src/sgml/runtime.sgml | 79 ++

pgsql: doc: Add advice about systemd RemoveIPC

2017-12-08 Thread Peter Eisentraut
doc: Add advice about systemd RemoveIPC Reviewed-by: Magnus Hagander Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5f82b3f7c60c6a4257c8693fbd500cbf3916fea9 Modified Files -- doc/src/sgml/runtime.sgml | 79 ++

pgsql: doc: Add advice about systemd RemoveIPC

2017-12-08 Thread Peter Eisentraut
doc: Add advice about systemd RemoveIPC Reviewed-by: Magnus Hagander Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2b1bf3fa32fbe8dc955cb064fbf1be7573556392 Modified Files -- doc/src/sgml/runtime.sgml | 79 ++

pgsql: Accept SCRAM channel binding enabled clients

2017-12-08 Thread Peter Eisentraut
Accept SCRAM channel binding enabled clients Add support to the SCRAM exchange for clients that support channel binding, such as PostgreSQL version 11 and beyond. If such a client encounters a PostgreSQL 10 server that does not support channel binding, it will send a channel binding flag 'y', mea

pgsql: Apply identity sequence values on COPY

2017-12-08 Thread Peter Eisentraut
Apply identity sequence values on COPY A COPY into a table should apply identity sequence values just like it does for ordinary defaults. This was previously forgotten, leading to null values being inserted, which in turn would fail because identity columns have not-null constraints. Author: Mic

pgsql: Apply identity sequence values on COPY

2017-12-08 Thread Peter Eisentraut
Apply identity sequence values on COPY A COPY into a table should apply identity sequence values just like it does for ordinary defaults. This was previously forgotten, leading to null values being inserted, which in turn would fail because identity columns have not-null constraints. Author: Mic