Implicit transactions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 169
Joined: Thu 03 Jul 2008 23:55

Implicit transactions

Post by JORGEMAL » Mon 21 Nov 2011 23:24

PostgreSQL 9.0 documentation says the following about transactions:

"PostgreSQL actually treats every SQL statement as being executed within a transaction. If you do not issue a BEGIN command, then each individual statement has an implicit BEGIN and (if successful) COMMIT wrapped around it."

Does this apply for dotConnect for PostgreSQL provider?

Jorge Maldonado

Site Admin
Posts: 8474
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 23 Nov 2011 14:11

This is true if you are not using local (PgSqlConnection.BeginTransaction()) or distributed (TransactionScope) transactions. Because in case of explicit transactions you determine in your code yourself when transaction has to be started and committed.

Post Reply