Postgres Pro
Downloads
Home   >   mailing lists

Re: set autocommit only for select statements - Mailing list pgsql-admin

From Mladen Gogala
Subject Re: set autocommit only for select statements
Date
Msg-id 37b5b251-83f8-56bc-579d-882daaa4fc47@gmail.com
Whole thread Raw
In response to Re: set autocommit only for select statements  (Holger Jakobs <holger@jakobs.com>)
Responses Re: set autocommit only for select statements
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: set autocommit only for select statements
Next
From: Simon Riggs
Date:
Subject: Re: set autocommit only for select statements