Confused about transactions

[TonyV]

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]

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]

Shalex:

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

Please disregard this issue.

Thanks

Tony