Re: Commit not required for update statement - Mailing list pgsql-admin

From Mark Kirkwood
Subject Re: Commit not required for update statement
Date
Msg-id 04dc9255-3b96-1d82-333d-a902c143d779@catalyst.net.nz
Whole thread Raw
In response to Re: Commit not required for update statement  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
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 <prasanna2mail@gmail.com 
> <mailto:prasanna2mail@gmail.com>> 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.
>



pgsql-admin by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: How should the correct value of shmmax be calculated for DWH(OLAP) server
Next
From: Laurenz Albe
Date:
Subject: Re: How should the correct value of shmmax be calculated for DWH(OLAP) server