Confused about transactions

Confused about transactions

Postby TonyV » Tue 13 Mar 2012 13:21

In this page: http://www.devart.com/dotconnect/postgresql/docs/Devart.Data.PostgreSql~Devart.Data.PostgreSql.PgSqlTransaction.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
TonyV
 
Posts: 74
Joined: Wed 25 May 2011 15:03

Postby Shalex » Wed 14 Mar 2012 10:04

1. PostgreSQL server doesn't support nested transactions.
2. The PgSqlTransaction class doesn't have the Close() method.
3. Could you please post here or send us a small test project to reproduce the "Connecction must be opened" issue?
Shalex
Devart Team
 
Posts: 7659
Joined: Thu 14 Aug 2008 12:44

Please consolidate this item with my other post

Postby TonyV » Thu 15 Mar 2012 00:39

Shalex:

This is related to my other post here:
http://www.devart.com/forums/viewtopic.php?p=79326#79326

Please disregard this issue.

Thanks

Tony
TonyV
 
Posts: 74
Joined: Wed 25 May 2011 15:03


Return to dotConnect for PostgreSQL