Confused about transactions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
TonyV
Posts: 74
Joined: Wed 25 May 2011 15:03

Confused about transactions

Post by TonyV » 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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by 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?

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

Please consolidate this item with my other post

Post by TonyV » Thu 15 Mar 2012 00:39

Shalex:

This is related to my other post here:
http://www.devart.com/forums/viewtopic. ... 9326#79326

Please disregard this issue.

Thanks

Tony

Post Reply