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