Implicit transactions

Implicit transactions

Postby 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?

Respectfully,
Jorge Maldonado
JORGEMAL
 
Posts: 165
Joined: Thu 03 Jul 2008 23:55

Postby 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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL