Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5B3F79F9C6E for ; Tue, 25 Sep 2007 11:25:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67461-01 for ; Tue, 25 Sep 2007 11:24:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail128153.authsmtp.com (outmail128153.authsmtp.com [62.13.128.153]) by postgresql.org (Postfix) with ESMTP id 653919F9C08 for ; Tue, 25 Sep 2007 11:24:53 -0300 (ADT) Received: from outmail128177.authsmtp.com (outmail128177.authsmtp.com [62.13.128.177]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l8PEOmPs035242; Tue, 25 Sep 2007 15:24:50 +0100 (BST) Received: from [192.168.0.3] (85-211-149-22.dyn.gotadsl.co.uk [85.211.149.22]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l8PEOkoB034724; Tue, 25 Sep 2007 15:24:47 +0100 (BST) Subject: Re: when transaction commit begins From: Simon Riggs To: Tom Lane Cc: pgsql-docs@postgresql.org In-Reply-To: <17900.1190726642@sss.pgh.pa.us> References: <1190713201.4181.350.camel@ebony.site> <17900.1190726642@sss.pgh.pa.us> Content-Type: text/plain Date: Tue, 25 Sep 2007 15:23:26 +0100 Message-Id: <1190730206.4181.485.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 1187dd1b-6b73-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagBbflxB HGQLW1NEUVh7W2d/ bw0fZQBDYEtPQQRu WVZLQE1QERpoT0AJ ZmthCUYAdwZCf3x0 K0djX3gVXUVychIp QxxJEz8BZnphaTRM TRJQcVJJcANLfxdA PlN4UyBcLwdSbGoL MygYBAV5IjVSLmxJ WAgLNlsZXUcMGHY3 QBUHHClnF0AKRiMo RyAn X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/23 X-Sequence-Number: 4421 On Tue, 2007-09-25 at 09:24 -0400, Tom Lane wrote: > Simon Riggs writes: > > I'd like to reword this line in the Asynch commit docs: > > "when transaction commit begins." > > I do not think your proposed rewording is better. OK > The point I was > trying to cover is that "SET LOCAL synchronous_commit" will affect the > upcoming commit, and that fine point is no longer clear with your > phrasing. So we both agree we want to make sure that point is understood. Saying it explicitly would be the best way, however we word the earlier piece. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com