Confused about transactions
Posted: Tue 13 Mar 2012 13:21
In this page: http://www.devart.com/dotconnect/postgr ... ction.html the following statement is made:
"The correlation between PgSqlConnection and PgSqlTransaction is always 1:1."
Does that mean that you can't nest transactions? What happens if you call PgSqlConnection.BeginTransaction a second time? WIl lyou get the same PgSqlTransaction object back?
We're geting error messages that read "Connecction must be opened". If you can only have one transaction open, and it closes after you call Transaction.Close(), this might explain why we're getting the messages.
Tony
"The correlation between PgSqlConnection and PgSqlTransaction is always 1:1."
Does that mean that you can't nest transactions? What happens if you call PgSqlConnection.BeginTransaction a second time? WIl lyou get the same PgSqlTransaction object back?
We're geting error messages that read "Connecction must be opened". If you can only have one transaction open, and it closes after you call Transaction.Close(), this might explain why we're getting the messages.
Tony