pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
REL9_6_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/06d47f6dc6e338e44700a51ad6dff1e855a6aa33

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
REL9_3_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/96e578b6c89f8532fe723bce45f78b558bd6bcca

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
REL9_4_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/3c74f7af075b6efe80416d019bfb3784d4785bf2

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/2c852e3e53c8e64b84f518ee2ab04509c3f29b95

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/9de7ae32cfea40e16b9e53523aa4f94f17fa2881

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
REL9_5_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/028f855845a5dde3d44ac02dc27a3c6b14dad01e

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: clarify plpython SD and GD dictionary behavior

2018-08-25 Thread Bruce Momjian
docs:  clarify plpython SD and GD dictionary behavior

Reported-by: Adam Bielański

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.3

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/a6ca9c2a1bd0d57e8f359504e91ee0208f65ed58

Modified Files
--
doc/src/sgml/plpython.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: docs: Clarify pg_ctl initdb option text to match options proto.

2018-08-25 Thread Bruce Momjian
docs:  Clarify pg_ctl initdb option text to match options proto.

The options string appeared in PG 10.

Reported-by: [email protected]

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 10

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/dfd840f105506db988566436c1559866bd73ab55

Modified Files
--
doc/src/sgml/ref/pg_ctl-ref.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgsql: docs: Clarify pg_ctl initdb option text to match options proto.

2018-08-25 Thread Bruce Momjian
docs:  Clarify pg_ctl initdb option text to match options proto.

The options string appeared in PG 10.

Reported-by: [email protected]

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 10

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/7abf8ee1e841684cd51472a7476b3f6b9441e70f

Modified Files
--
doc/src/sgml/ref/pg_ctl-ref.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgsql: docs: Clarify pg_ctl initdb option text to match options proto.

2018-08-25 Thread Bruce Momjian
docs:  Clarify pg_ctl initdb option text to match options proto.

The options string appeared in PG 10.

Reported-by: [email protected]

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 10

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/04d36cf44bcc14c649037470e72fb990e794e212

Modified Files
--
doc/src/sgml/ref/pg_ctl-ref.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgsql: Comment fix for rewriteheap.h.

2018-08-25 Thread Jeff Davis
Comment fix for rewriteheap.h.

The description of the filename for mapping files did not match the
code.

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/e75733d46c8444c0f5c9578bdf576b29039aac1f

Modified Files
--
src/include/access/rewriteheap.h | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)



pgsql: Change extension of spilled ReorderBufferChange data to ".tmp".

2018-08-25 Thread Jeff Davis
Change extension of spilled ReorderBufferChange data to ".tmp".

The previous extension, ".snap", was chosen for historical reasons and
became confusing.

Discussion: 
https://postgr.es/m/CAMp0ubd_P8vBGx8=mfdxqjzxha5d_zarw5cckdxj_63+pwr...@mail.gmail.com

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/91f26d5fe47e3b06e878f2f1949cbd35e9576c16

Modified Files
--
src/backend/replication/logical/reorderbuffer.c | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



Re: pgsql: Change extension of spilled ReorderBufferChange data to ".tmp".

2018-08-25 Thread Andres Freund



Hi,

On August 25, 2018 9:39:12 AM PDT, Jeff Davis  wrote:
>Change extension of spilled ReorderBufferChange data to ".tmp".
>
>The previous extension, ".snap", was chosen for historical reasons and
>became confusing.

Not a fan of .tmp, that well just lead to people deleting them while the server 
is running etc. How about .spill or such?

Andres

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
REL9_3_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/ebc0d6be1d10a5d4c8bc6fcec90f4f976d35b267

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
REL9_4_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/fe6131b4a81231526e5841f4ba187ec1d725de7b

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/3c712c580e63a983081758059607ca1ee4bc4b6b

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
REL9_6_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/a65f22fc6223117650fec31a3821f181f15d9366

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/943f75d543e10fed4215d21dd985a5e215fae56c

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/dcb2efdbdd8fe46be35069ea58acebbc4ff2723a

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



pgsql: doc: add doc link for 'applicable_roles'

2018-08-25 Thread Bruce Momjian
doc:  add doc link for 'applicable_roles'

Reported-by: Ashutosh Sharma

Discussion: 
https://postgr.es/m/cae9k0pnhnl6mndluvkk8uszoa_dpzdzfqpam_uaguxbh9hm...@mail.gmail.com

Author: Ashutosh Sharma

Backpatch-through: 9.3

Branch
--
REL9_5_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/56c1d751cf16d7be72131085d70fb027f83d2e1a

Modified Files
--
doc/src/sgml/information_schema.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)



Re: pgsql: Change extension of spilled ReorderBufferChange data to ".tmp".

2018-08-25 Thread Tom Lane
Andres Freund  writes:
> On August 25, 2018 9:39:12 AM PDT, Jeff Davis  wrote:
>> Change extension of spilled ReorderBufferChange data to ".tmp".
>> The previous extension, ".snap", was chosen for historical reasons and
>> became confusing.

> Not a fan of .tmp, that well just lead to people deleting them while the 
> server is running etc. How about .spill or such?

Agreed, ".tmp" seems like a bad idea.

regards, tom lane



pgsql: doc: "Latest checkpoint location" will not match in pg_upgrade

2018-08-25 Thread Bruce Momjian
doc:  "Latest checkpoint location" will not match in pg_upgrade

Mention that "Latest checkpoint location" will not match in pg_upgrade
if the standby server is still running during the upgrade, which is
possible.  "Match" text first appeared in PG 9.5.

Reported-by: Paul Bonaud

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.5

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/474d8102466e7d3a4aaa9ec4e68d38371247faac

Modified Files
--
doc/src/sgml/ref/pgupgrade.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



pgsql: doc: "Latest checkpoint location" will not match in pg_upgrade

2018-08-25 Thread Bruce Momjian
doc:  "Latest checkpoint location" will not match in pg_upgrade

Mention that "Latest checkpoint location" will not match in pg_upgrade
if the standby server is still running during the upgrade, which is
possible.  "Match" text first appeared in PG 9.5.

Reported-by: Paul Bonaud

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.5

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/cc2e457fe8a3f685b4f9b9dce05b0c027b39459f

Modified Files
--
doc/src/sgml/ref/pgupgrade.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



pgsql: doc: "Latest checkpoint location" will not match in pg_upgrade

2018-08-25 Thread Bruce Momjian
doc:  "Latest checkpoint location" will not match in pg_upgrade

Mention that "Latest checkpoint location" will not match in pg_upgrade
if the standby server is still running during the upgrade, which is
possible.  "Match" text first appeared in PG 9.5.

Reported-by: Paul Bonaud

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.5

Branch
--
REL9_6_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/50ff8844bb3b32fbc2a4d1b2d4fe22b4e5efd779

Modified Files
--
doc/src/sgml/ref/pgupgrade.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



pgsql: doc: "Latest checkpoint location" will not match in pg_upgrade

2018-08-25 Thread Bruce Momjian
doc:  "Latest checkpoint location" will not match in pg_upgrade

Mention that "Latest checkpoint location" will not match in pg_upgrade
if the standby server is still running during the upgrade, which is
possible.  "Match" text first appeared in PG 9.5.

Reported-by: Paul Bonaud

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.5

Branch
--
REL9_5_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/3e8382996ffaea16e4202172d32ca72b672056b4

Modified Files
--
doc/src/sgml/ref/pgupgrade.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



pgsql: doc: "Latest checkpoint location" will not match in pg_upgrade

2018-08-25 Thread Bruce Momjian
doc:  "Latest checkpoint location" will not match in pg_upgrade

Mention that "Latest checkpoint location" will not match in pg_upgrade
if the standby server is still running during the upgrade, which is
possible.  "Match" text first appeared in PG 9.5.

Reported-by: Paul Bonaud

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.5

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/231cf30e984b1501cbe640f567c08919a195d9d1

Modified Files
--
doc/src/sgml/ref/pgupgrade.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)



pgsql: doc: correct syntax of pgtrgm examples in older releases

2018-08-25 Thread Bruce Momjian
doc:  correct syntax of pgtrgm examples in older releases

Reported-by: Liudmila Mantrova

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.6 and 10 only

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/993b5a78adff29fc58e7449cab98bb865b77c663

Modified Files
--
doc/src/sgml/pgtrgm.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: doc: correct syntax of pgtrgm examples in older releases

2018-08-25 Thread Bruce Momjian
doc:  correct syntax of pgtrgm examples in older releases

Reported-by: Liudmila Mantrova

Discussion: 
https://postgr.es/m/[email protected]

Backpatch-through: 9.6 and 10 only

Branch
--
REL9_6_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/c2ea62f58575045bd85156581f55b57067f33fd8

Modified Files
--
doc/src/sgml/pgtrgm.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgsql: Reconsider new file extension in commit 91f26d5f.

2018-08-25 Thread Jeff Davis
Reconsider new file extension in commit 91f26d5f.

Andres and Tom objected to the choice of the ".tmp"
extension. Changing to Andres's suggestion of ".spill".

Discussion: 
https://postgr.es/m/88092095-3348-49D8-8746-EB574B1D30EA%40anarazel.de

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/ba9d35b8eb8466cf445c732a2e15ca5790cbc6c6

Modified Files
--
src/backend/replication/logical/reorderbuffer.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)