[COMMITTERS] pgsql: Remove dependency on wsock32.lib in favor of ws2_32

2014-07-15 Thread Magnus Hagander
Remove dependency on wsock32.lib in favor of ws2_32 ws2_32 is the new version of the library that should be used, as it contains the require functionality from wsock32 as well as some more (which is why some binaries were already using ws2_32). Michael Paquier, reviewed by MauMau Branch -- m

[COMMITTERS] pgsql: Add missing serial commas

2014-07-15 Thread Peter Eisentraut
Add missing serial commas Also update one place where the wal_level "logical" was not added to an error message. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/350651905decd60637e583837d3bb3aa5d9164b6 Modified Files -- src/backend/access/transam/

[COMMITTERS] pgsql: Add missing serial commas

2014-07-15 Thread Peter Eisentraut
Add missing serial commas Also update one place where the wal_level "logical" was not added to an error message. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d38228fe4029cce3af396bf5b1728d8000ab32c8 Modified Files -- src/backend/access/transam/xlog.c

[COMMITTERS] pgsql: Small spelling fix

2014-07-15 Thread Peter Eisentraut
Small spelling fix Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/d90ad5d8abe7947520686239a7547f2eb8cc9a8d Modified Files -- src/backend/catalog/objectaddress.c |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committers maili

[COMMITTERS] pgsql: Include SSL compression status in psql banner and connection log

2014-07-15 Thread Magnus Hagander
Include SSL compression status in psql banner and connection logging Both the psql banner and the connection logging already included SSL status, cipher and bitlength, this adds the information about compression being on or off. Branch -- master Details --- http://git.postgresql.org/pg/c

[COMMITTERS] pgsql: Include SSL compression status in psql banner and connection log

2014-07-15 Thread Magnus Hagander
Include SSL compression status in psql banner and connection logging Both the psql banner and the connection logging already included SSL status, cipher and bitlength, this adds the information about compression being on or off. Branch -- REL9_4_STABLE Details --- http://git.postgresql.o

[COMMITTERS] pgsql: Reset master xmin when hot_standby_feedback disabled.

2014-07-15 Thread Simon Riggs
Reset master xmin when hot_standby_feedback disabled. If walsender has xmin of standby then ensure we reset the value to 0 when we change from hot_standby_feedback=on to hot_standby_feedback=off. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/2dde11a632d3fe309

[COMMITTERS] pgsql: Reset master xmin when hot_standby_feedback disabled.

2014-07-15 Thread Simon Riggs
Reset master xmin when hot_standby_feedback disabled. If walsender has xmin of standby then ensure we reset the value to 0 when we change from hot_standby_feedback=on to hot_standby_feedback=off. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/8ebf5f7206e0e4c5d

[COMMITTERS] pgsql: Add missing source files to nls.mk

2014-07-15 Thread Peter Eisentraut
Add missing source files to nls.mk These are files under common/ that have been moved around. Updating these manually is not satisfactory, but it's the only solution at the moment. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/77b41010dbb159b77b35aef02b517c

[COMMITTERS] pgsql: Add missing source files to nls.mk

2014-07-15 Thread Peter Eisentraut
Add missing source files to nls.mk These are files under common/ that have been moved around. Updating these manually is not satisfactory, but it's the only solution at the moment. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f9ddcf75430467493aa6c2b07a45776e4ae8b

Re: [COMMITTERS] pgsql: psql: Show tablespace size in \db+

2014-07-15 Thread Tom Lane
Alvaro Herrera writes: > psql: Show tablespace size in \db+ Surely this should have included a documentation update. regards, tom lane -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresq

[COMMITTERS] pgsql: Detect presence of SSL_get_current_compression

2014-07-15 Thread Magnus Hagander
Detect presence of SSL_get_current_compression Apparently we still build against OpenSSL so old that it doesn't have this function, so add an autoconf check for it to make the buildfarm happy. If the function doesn't exist, always return that compression is disabled, since presumably the actual co

[COMMITTERS] pgsql: Detect presence of SSL_get_current_compression

2014-07-15 Thread Magnus Hagander
Detect presence of SSL_get_current_compression Apparently we still build against OpenSSL so old that it doesn't have this function, so add an autoconf check for it to make the buildfarm happy. If the function doesn't exist, always return that compression is disabled, since presumably the actual co

Re: [COMMITTERS] pgsql: psql: Show tablespace size in \db+

2014-07-15 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera writes: > > psql: Show tablespace size in \db+ > > Surely this should have included a documentation update. Bah, you're right. I was going by cae10ca27e5d478353b9b053073e5f2a1cf97659 which didn't include one either. I guess I didn't look hard enough. Will fix.

Re: [COMMITTERS] pgsql: Move view reloptions into their own varlena struct

2014-07-15 Thread Tom Lane
Alvaro Herrera writes: > Tom Lane wrote: >> Alvaro Herrera writes: >>> Move view reloptions into their own varlena struct >> Shouldn't this have included a catversion bump? > Hmm ... I'm not sure I see a reason for that. Parsed reloptions are not > stored on disk anywhere, and this patch doesn

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

Re: [COMMITTERS] pgsql: Move view reloptions into their own varlena struct

2014-07-15 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera writes: > > Move view reloptions into their own varlena struct > > Shouldn't this have included a catversion bump? Hmm ... I'm not sure I see a reason for that. Parsed reloptions are not stored on disk anywhere, and this patch doesn't change how they are represe

[COMMITTERS] pgsql: Fix REASSIGN OWNED for text search objects

2014-07-15 Thread Alvaro Herrera
Fix REASSIGN OWNED for text search objects Trying to reassign objects owned by a user that had text search dictionaries or configurations used to fail with: ERROR: unexpected classid 3600 or ERROR: unexpected classid 3602 Fix by adding cases for those object types in a switch in pg_shdepend.c.

[COMMITTERS] pgsql: Add missing doc changes for ee80f043bc9b

2014-07-15 Thread Alvaro Herrera
Add missing doc changes for ee80f043bc9b Per note from Tom Lane Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/da6ac4a6683788ed7042a46568f2b040210830f8 Modified Files -- doc/src/sgml/ref/psql-ref.sgml |5 +++-- 1 file changed, 3 insertions(+), 2 dele

[COMMITTERS] pgsql: json_build_object and json_build_array are stable, not immutable

2014-07-15 Thread Andrew Dunstan
json_build_object and json_build_array are stable, not immutable. These functions indirectly invoke output functions, so they can't be immutable. Backpatch to 9.4 where they were introduced. Catalog version bumped. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commit

[COMMITTERS] pgsql: json_build_object and json_build_array are stable, not immutable

2014-07-15 Thread Andrew Dunstan
json_build_object and json_build_array are stable, not immutable. These functions indirectly invoke output functions, so they can't be immutable. Backpatch to 9.4 where they were introduced. Catalog version bumped. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/0f

[COMMITTERS] pgsql: doc: Put new options in right order on reference pages

2014-07-15 Thread Peter Eisentraut
doc: Put new options in right order on reference pages Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/3b70e973cf8363c84b2ef2958aea38f523765f44 Modified Files -- doc/src/sgml/pgbench.sgml | 24 doc/src/sgml/ref/pg_dump

[COMMITTERS] pgsql: doc: Put new options in right order on reference pages

2014-07-15 Thread Peter Eisentraut
doc: Put new options in right order on reference pages Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9a218c02b8f10bc5aa3a9227b0a30ad0b6bdf6a6 Modified Files -- doc/src/sgml/pgbench.sgml | 24 doc/src/sgml/ref/pg_dump.sgml |

[COMMITTERS] pgsql: pg_basebackup: Add more information about --max-rate option to h

2014-07-15 Thread Peter Eisentraut
pg_basebackup: Add more information about --max-rate option to help output It was previously not clear what unit the option argument should have. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/7466037596bfdf1223f1759c7a0e4aaabff0cb53 Modified Files -

[COMMITTERS] pgsql: pg_upgrade: Fix spacing in help output

2014-07-15 Thread Peter Eisentraut
pg_upgrade: Fix spacing in help output Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/e763ec989cb8b75ab010cc809cf9f5d6c2418da0 Modified Files -- contrib/pg_upgrade/option.c |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgs

[COMMITTERS] pgsql: pg_basebackup: Add more information about --max-rate option to h

2014-07-15 Thread Peter Eisentraut
pg_basebackup: Add more information about --max-rate option to help output It was previously not clear what unit the option argument should have. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e806da6bdbe9544e061b635f33b8ee561094b4d0 Modified Files -- s

[COMMITTERS] pgsql: pg_upgrade: Fix spacing in help output

2014-07-15 Thread Peter Eisentraut
pg_upgrade: Fix spacing in help output Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e0da6ec618a3890d7d5d8b8342645e6683848d67 Modified Files -- contrib/pg_upgrade/option.c |2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-comm

[COMMITTERS] pgsql: Move check for SSL_get_current_compression to run on mingw

2014-07-15 Thread Magnus Hagander
Move check for SSL_get_current_compression to run on mingw Mingw uses a different header file than msvc, so we don't get the hardcoded value, so we need the configure test to run. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5571caf42d62ea30c452b0ae5f1748289ae613b

[COMMITTERS] pgsql: Move check for SSL_get_current_compression to run on mingw

2014-07-15 Thread Magnus Hagander
Move check for SSL_get_current_compression to run on mingw Mingw uses a different header file than msvc, so we don't get the hardcoded value, so we need the configure test to run. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/0e34d82538bd48fc537d512539cee014

[COMMITTERS] pgsql: Allow join removal in some cases involving a left join to a subq

2014-07-15 Thread Tom Lane
Allow join removal in some cases involving a left join to a subquery. We can remove a left join to a relation if the relation's output is provably distinct for the columns involved in the join clause (considering only equijoin clauses) and the relation supplies no variables needed above the join.

[COMMITTERS] pgsql: Fix bugs in SP-GiST search with range type's -|- (adjacent) oper

2014-07-15 Thread Heikki Linnakangas
Fix bugs in SP-GiST search with range type's -|- (adjacent) operator. The consistent function contained several bugs: * The "if (which2) { ... }" block was broken. It compared the argument's lower bound against centroid's upper bound, while it was supposed to compare the argument's upper bound

[COMMITTERS] pgsql: Fix bugs in SP-GiST search with range type's -|- (adjacent) oper

2014-07-15 Thread Heikki Linnakangas
Fix bugs in SP-GiST search with range type's -|- (adjacent) operator. The consistent function contained several bugs: * The "if (which2) { ... }" block was broken. It compared the argument's lower bound against centroid's upper bound, while it was supposed to compare the argument's upper bound

[COMMITTERS] pgsql: Fix bugs in SP-GiST search with range type's -|- (adjacent) oper

2014-07-15 Thread Heikki Linnakangas
Fix bugs in SP-GiST search with range type's -|- (adjacent) operator. The consistent function contained several bugs: * The "if (which2) { ... }" block was broken. It compared the argument's lower bound against centroid's upper bound, while it was supposed to compare the argument's upper bound