Page 1 of 1

syntax error at end of input when opening Transaction

Posted: Mon 19 Sep 2005 08:05
by Arnaud
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,

syntax error at end of input when opening Transaction

Posted: Thu 22 Sep 2005 08:51
by Yuri
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.

Re: syntax error at end of input when opening Transaction

Posted: Mon 26 Sep 2005 09:31
by Arnaud
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,

syntax error at end of input when opening Transaction

Posted: Mon 26 Sep 2005 09:37
by Yuri
We are planning to release new version in a week.