Support for distributed transactions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
ChristianStaffe
Posts: 1
Joined: Wed 03 Sep 2008 07:09

Support for distributed transactions

Post by ChristianStaffe » Wed 03 Sep 2008 08:10

Hi,

Does the PostgreSQLDirect.NET provider support distributed transactions, automatically enlisting into existing transactions and thus taking part into distributed transactions with other providers (TransactionScope).

For instance:

using (TransactionScope scope = new TransactionScope())
{
// open a PostgreSQL Direct.NET connection here
// update some db data here
// if something fails here, exception is thrown, update db is rollbacked
scope.complete();
// transaction is committed only now !
}

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

Post by Shalex » Fri 05 Sep 2008 12:11

PostgreSQLDirect .NET doesn't support distributed transactions now. This functionality will be implemented in the future, but no timeframe can be provided.

Post Reply