| From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, prasanna rk <prasanna2mail(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Commit not required for update statement |
| Date: | 2018-10-15 08:16:14 |
| Message-ID: | 04dc9255-3b96-1d82-333d-a902c143d779@catalyst.net.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)com
> <mailto:prasanna2mail(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2018-10-15 08:21:09 | Re: How should the correct value of shmmax be calculated for DWH (OLAP) server |
| Previous Message | Gunnar "Nick" Bluth | 2018-10-15 07:49:02 | Re: How should the correct value of shmmax be calculated for DWH (OLAP) server |