Re: returning does not act as expected after viewing documentation

2019-09-23 Thread lennart rolland
Facepalm. Please disregard my rookie mistake! On Tue, Sep 24, 2019, 00:18 David G. Johnston wrote: > On Mon, Sep 23, 2019 at 2:45 PM PG Doc comments form < > nore...@postgresql.org> wrote: > >> update batch_log >> set status=('in-progress'), >> updated_at=now() >> [...] >> returning id, batch_l

Re: returning does not act as expected after viewing documentation

2019-09-23 Thread David G. Johnston
On Mon, Sep 23, 2019 at 2:45 PM PG Doc comments form wrote: > update batch_log > set status=('in-progress'), > updated_at=now() > [...] > returning id, batch_log.update_at > ; > > column batch_log.update_at does not exist > LINE 14: returning id, batch_log.update_at > HINT: Perhaps you mea

returning does not act as expected after viewing documentation

2019-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/dml-returning.html Description: With the following query: update batch_log set status=('in-progress'), updated_at=now() where status = ('pending') and id = ( select id from batch_log

Re: invalid ldconfig [option]

2019-09-23 Thread Umberto
Dear Tom Lane, I'm sorry.  You are in right. I read not carefully and I've hop a line. The code is for BSD and not linux. Regards Umberto Otto On 23/09/2019 16:21, Tom Lane wrote: PG Doc comments form writes: Page: https://www.postgresql.org/docs/11/install-post.html In the line "/sbin/ldco

Re: @> (contains)

2019-09-23 Thread Tom Lane
"David G. Johnston" writes: > On Sun, Aug 18, 2019 at 8:53 AM PG Doc comments form >> Noticed strange thin with @> >> Query "select '{1,2}'::int[] @> '{1,2,2,2,2,2,2,2}'::int[]" returns true, >> but first array contains even less elements then second. >> I think it's a bug in "contains" logic, bu

Do not use C++ style comments (// comments). Strict ANSI C compilers do not accept them.

2019-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/source-format.html Description: This sentence in the style guide feels outdated. // style comments have been in the ANSI C standard for almost 20 years now (C99 was accepted as ANSI standa

Re: fix tags in v12 Release Notes

2019-09-23 Thread Tom Lane
Liudmila Mantrova writes: > Please consider fixing a couple of tagging issues in v12 Release notes > discovered during translation. A trivial patch is attached. I pushed most of this. I did tweak where the link for vacuumdb went --- I think Bruce's usual practice is to put a only on the first r

Re: Fix contributor name-related inconsistencies in release-12.sgml

2019-09-23 Thread Tom Lane
Alexander Lakhin writes: > While translating Release Notes for version 12 I found some > inconsistencies with contributor names. Proposed changes seem reasonable from here. Pushed, thanks! regards, tom lane

Re: invalid ldconfig [option]

2019-09-23 Thread Tom Lane
PG Doc comments form writes: > Page: https://www.postgresql.org/docs/11/install-post.html > In the line "/sbin/ldconfig -m /usr/local/pgsql/lib" the "-m" is a invalid > option. I think is a mispelling of a "-n" option. Invalid according to who? The page says that that version of the command is

fix tags in v12 Release Notes

2019-09-23 Thread Liudmila Mantrova
Hi, Please consider fixing a couple of tagging issues in v12 Release notes discovered during translation. A trivial patch is attached. -- Best regards, Liudmila Mantrova Technical writer at Postgres Professional: http://www.postgrespro.com diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgm

Fix contributor name-related inconsistencies in release-12.sgml

2019-09-23 Thread Alexander Lakhin
Hello, While translating Release Notes for version 12 I found some inconsistencies with contributor names. 1. Constantine Kuznetsov and Konstantin Kuznetsov are the same person. 2. Sho Kato and Kato Sho too. 3. Takayuki Tsunakawa is present in the Acknowledgments, but Tsunakawa Takayuki is referre

invalid ldconfig [option]

2019-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/install-post.html Description: In the line "/sbin/ldconfig -m /usr/local/pgsql/lib" the "-m" is a invalid option. I think is a mispelling of a "-n" option. Best Regards umbo