Page 1 of 1

Implicit transactions

Posted: Mon 21 Nov 2011 23:24
by JORGEMAL
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

Posted: Wed 23 Nov 2011 14:11
by Shalex
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.