Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBy3D-00042p-05 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 08:16:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gBy3A-0007NG-Sc for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 08:16:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBy3A-0007N9-Kx for pgsql-admin@lists.postgresql.org; Mon, 15 Oct 2018 08:16:28 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gBy36-00036z-Hu for pgsql-admin@lists.postgresql.org; Mon, 15 Oct 2018 08:16:27 +0000 Received: from [IPv6:2406:e001:b7c:1:74e4:2a2f:5cd8:9650] (unknown [IPv6:2406:e001:b7c:1:74e4:2a2f:5cd8:9650]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id A83F480C1F; Mon, 15 Oct 2018 21:16:16 +1300 (NZDT) Subject: Re: Commit not required for update statement To: "David G. Johnston" , prasanna rk Cc: "pgsql-admin@lists.postgresql.org" References: <93cce450-1c0b-bbb1-9994-e386b7b45062@catalyst.net.nz> From: Mark Kirkwood Message-ID: <04dc9255-3b96-1d82-333d-a902c143d779@catalyst.net.nz> Date: Mon, 15 Oct 2018 21:16:14 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US Authentication-Results: ORIGINATING; auth=pass smtp.auth=mark.kirkwood@catalyst.net.nz smtp.mailfrom=mark.kirkwood@catalyst.net.nz List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Yeah - it matters whether you using psql client or python db api (for example) - as some of these decide to open a transaction immediately after a connection is established (via BEGIN) . So reading the docs and experimenting as indicated is essential! regards Mark On 15/10/18 18:58, David G. Johnston wrote: > On Sunday, October 14, 2018, prasanna rk > wrote: > > Does this mean..every statement which does not have begin will be > automatically commited. > > > You should experiment in your chosen environment and see what does and > doesn’t work. > > David J. >