Re: Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level"

2021-08-18 Thread radiodiversion
Hi, David! Thanks for the explanation! Now I clearly understand how it works. I still think it would be great if this doc point was worded a little differently in new editions. Thank you! On Wed, 18 Aug 2021 at 02:03, David G. Johnston wrote: > On Tue, Aug 17, 2021 at 3:56 PM PG Doc comments

Re: Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level"

2021-08-18 Thread radiodiversion
David, I have some suggestions. but first i want to show how the current version of doc may look like for new readers. and why. I am sure that it looks pretty logical if you KNOW how it works, but it is not so clear if you WANT to learn that from documentation. explanation: first sentence: "they

Re: Clarify how triggers relate to transactions

2021-08-18 Thread Laurenz Albe
On Fri, 2021-07-30 at 16:20 -0400, Tom Lane wrote: > Laurenz Albe writes: > > On Wed, 2021-04-28 at 13:24 +0200, Laurenz Albe wrote: > > > On Tue, 2021-04-27 at 14:26 +, PG Doc comments form wrote: > > > > If I understand correctly, it would be helpful to add this sentence or a > > > > correct

Re: Improve documentation for pg_upgrade, standbys and rsync

2021-08-18 Thread Laurenz Albe
On Mon, 2021-07-26 at 15:11 -0400, Stephen Frost wrote: > > > > > An additional thing that we should really be mentioning is to tell > > > > > people to go in and TRUNCATE all of their UNLOGGED tables before going > > > > > through this process, otherwise the rsync will end up spending a bunch > >

Re: ECPG cursor examples should include EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while loop

2021-08-18 Thread Bruce Momjian
On Sat, Jul 3, 2021 at 11:54:11AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/ecpg-variables.html > Description: > > Without this line: > EXEC SQL WHENEVER NOT FOUND CONTINUE; > after the wh