Content-Type: multipart/alternative;
 boundary="------------YTDUSUI9Ux0tnXll07TZ4ECw"
Message-ID: <37b5b251-83f8-56bc-579d-882daaa4fc47@gmail.com>
Date: Tue, 12 Apr 2022 08:00:35 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.7.0
Subject: Re: set autocommit only for select statements
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: <548f2ed6-3209-705d-09e2-a5afbc6fb71c@quadratum-braccas.com>
 <bc177652-b317-0f78-cc82-466f24315549@gmail.com>
 <6bfd5d91-bb06-1b56-f4f8-cc8f90307a35@jakobs.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: <6bfd5d91-bb06-1b56-f4f8-cc8f90307a35@jakobs.com>
Archived-At: 
 <https://www.postgresql.org/message-id/37b5b251-83f8-56bc-579d-882daaa4fc47%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------YTDUSUI9Ux0tnXll07TZ4ECw
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 4/12/22 02:31, Holger Jakobs wrote:
> What you write about psql sending a COMMIT statement after each 
> statement is wrong. It may be true for other database systems.
>
> PostgreSQL as a server commits each statement automatically unless the 
> client has started a transaction with BEGIN or START TRANSACTION 
> statements.
>
> This can be proved easily by not using psql as a client, but some 
> programming language.
>
> Regards,

If what you are saying was true, then autocommit would be a database 
mode, not a tool mode. It isn't a database mode. Q.E.D.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--------------YTDUSUI9Ux0tnXll07TZ4ECw
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 4/12/22 02:31, Holger Jakobs wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:6bfd5d91-bb06-1b56-f4f8-cc8f90307a35@jakobs.com">What
      you write about psql sending a COMMIT statement after each
      statement is wrong. It may be true for other database systems.
      <br>
      <br>
      PostgreSQL as a server commits each statement automatically unless
      the client has started a transaction with BEGIN or START
      TRANSACTION statements.
      <br>
      <br>
      This can be proved easily by not using psql as a client, but some
      programming language.
      <br>
      <br>
      Regards,
      <br>
    </blockquote>
    <p>If what you are saying was true, then autocommit would be a
      database mode, not a tool mode. It isn't a database mode. Q.E.D.<br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>

--------------YTDUSUI9Ux0tnXll07TZ4ECw--