Re: [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZE colu

2017-09-25 Thread David G. Johnston
On Mon, Sep 25, 2017 at 1:50 PM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > On 9/25/17 15:09, Tom Lane wrote: > > Peter Eisentraut writes: > >> On 9/21/17 18:13, Tom Lane wrote: > >>> Give a better error for duplicate entries in VACUUM/ANALYZE column > list. > > > >> In the err

Re: [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZE colu

2017-09-25 Thread Peter Eisentraut
On 9/25/17 15:09, Tom Lane wrote: > Peter Eisentraut writes: >> On 9/21/17 18:13, Tom Lane wrote: >>> Give a better error for duplicate entries in VACUUM/ANALYZE column list. > >> In the error message, we should write "specified more than once" instead >> of "specified twice", because that could

[COMMITTERS] pgsql: Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs.

2017-09-25 Thread Tom Lane
Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs. On Linux, shared memory segments created with shm_open() are backed by swap files created in tmpfs. If the swap file needs to be extended, but there's no tmpfs space left, you get a very unfriendly SIGBUS trap. To avoid this, force a

[COMMITTERS] pgsql: Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs.

2017-09-25 Thread Tom Lane
Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs. On Linux, shared memory segments created with shm_open() are backed by swap files created in tmpfs. If the swap file needs to be extended, but there's no tmpfs space left, you get a very unfriendly SIGBUS trap. To avoid this, force a

[COMMITTERS] pgsql: Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs.

2017-09-25 Thread Tom Lane
Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs. On Linux, shared memory segments created with shm_open() are backed by swap files created in tmpfs. If the swap file needs to be extended, but there's no tmpfs space left, you get a very unfriendly SIGBUS trap. To avoid this, force a

[COMMITTERS] pgsql: Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs.

2017-09-25 Thread Tom Lane
Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs. On Linux, shared memory segments created with shm_open() are backed by swap files created in tmpfs. If the swap file needs to be extended, but there's no tmpfs space left, you get a very unfriendly SIGBUS trap. To avoid this, force a

[COMMITTERS] pgsql: Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs.

2017-09-25 Thread Tom Lane
Avoid SIGBUS on Linux when a DSM memory request overruns tmpfs. On Linux, shared memory segments created with shm_open() are backed by swap files created in tmpfs. If the swap file needs to be extended, but there's no tmpfs space left, you get a very unfriendly SIGBUS trap. To avoid this, force a

Re: [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZE colu

2017-09-25 Thread Tom Lane
Peter Eisentraut writes: > On 9/21/17 18:13, Tom Lane wrote: >> Give a better error for duplicate entries in VACUUM/ANALYZE column list. > In the error message, we should write "specified more than once" instead > of "specified twice", because that could otherwise look a bit silly: > VACUUM ANALY

Re: [COMMITTERS] pgsql: Give a better error for duplicate entries in VACUUM/ANALYZE colu

2017-09-25 Thread Peter Eisentraut
On 9/21/17 18:13, Tom Lane wrote: > Give a better error for duplicate entries in VACUUM/ANALYZE column list. > > Previously, the code didn't think about this case and would just try to > analyze such a column twice. In the error message, we should write "specified more than once" instead of "spec

[COMMITTERS] pgsql: Make construct_[md_]array return a valid empty array for zero-si

2017-09-25 Thread Tom Lane
Make construct_[md_]array return a valid empty array for zero-size input. If construct_array() or construct_md_array() were given a dimension of zero, they'd produce an array that contains no elements but has positive dimension. This violates a general expectation that empty arrays should have nd

[COMMITTERS] pgsql: Support building with Visual Studio 2017

2017-09-25 Thread Andrew Dunstan
Support building with Visual Studio 2017 Haribabu Kommi, reviewed by Takeshi Ideriha and Christian Ullrich Backpatch to 9.6 Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/99e90bac4f9f3bd8d7b285a6f4095c2089e09efe Modified Files -- doc/src/sgml/i

[COMMITTERS] pgsql: Support building with Visual Studio 2017

2017-09-25 Thread Andrew Dunstan
Support building with Visual Studio 2017 Haribabu Kommi, reviewed by Takeshi Ideriha and Christian Ullrich Backpatch to 9.6 Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/10aafbdbe4224846095198644a1169807ab9b391 Modified Files -- doc/src/sgml/i

[COMMITTERS] pgsql: Support building with Visual Studio 2017

2017-09-25 Thread Andrew Dunstan
Support building with Visual Studio 2017 Haribabu Kommi, reviewed by Takeshi Ideriha and Christian Ullrich Backpatch to 9.6 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f2ab3898f3a25ef431db4ea90a8d128b974dbffe Modified Files -- doc/src/sgml/install-