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
