syntax error at end of input when opening Transaction

syntax error at end of input when opening Transaction

Postby Arnaud » Mon 19 Sep 2005 08:05

Hi,

When I try to open a Transaction using:
Code: Select all
Connection.BeginTransaction(System.Data.IsolationLevel.RepeatableRead);


I receive the following Error:
Code: Select all
A first chance exception of type 'CoreLab.PostgreSql.PgSqlException' occurred in corelab.postgresql.dll

Additional information: syntax error at end of input


Does someone have any clue about this problem?

Many thanks for your help,

Regards,
Arnaud
 
Posts: 3
Joined: Fri 24 Jun 2005 14:12

syntax error at end of input when opening Transaction

Postby Yuri » Thu 22 Sep 2005 08:51

We reproduced problem and fixed it. This fix will be included in the next version of PostgreSqlDirect .NET provider. Use can use SERIALIZABLE isolation level in your code.
In PostgreSQL REPEATABLE READ is treated as SERIALIZABLE.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Re: syntax error at end of input when opening Transaction

Postby Arnaud » Mon 26 Sep 2005 09:31

Yuri wrote:We reproduced problem and fixed it. This fix will be included in the next version of PostgreSqlDirect .NET provider. Use can use SERIALIZABLE isolation level in your code.
In PostgreSQL REPEATABLE READ is treated as SERIALIZABLE.


Good morning,

It is nice to hear about a solution. But, could you tell us when you plan to deliver the new version. We are finalizing our project and we want to remove all the work-around due to bugs in order to provide a proper tool to our customer.

Thank you for updates.

Best regards,
Arnaud
 
Posts: 3
Joined: Fri 24 Jun 2005 14:12

syntax error at end of input when opening Transaction

Postby Yuri » Mon 26 Sep 2005 09:37

We are planning to release new version in a week.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL