public inbox for [email protected]  

help / color / mirror / Atom feed

From: Holger Jakobs <[email protected]>
To: [email protected]
Subject: Re: set autocommit only for select statements
Date: Tue, 12 Apr 2022 08:31:15 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Am 12.04.22 um 03:53 schrieb Mladen Gogala:
>
> The "autocommit" is a tool option which tells the tool whether to add 
> "COMMIT" statement after each and every SQL. The RDBMS server only 
> knows about transactions, as mandated by the ACID compliance. What the 
> "autocommit" option of tools like psql actually does is to turn each 
> of your SQL statements into a separate transaction.
>
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,

Holger


-- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


Attachments:

  [application/pgp-signature] OpenPGP_signature (203B, 2-OpenPGP_signature)
  download

view thread (9+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: set autocommit only for select statements
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox