syntax error at end of input when opening Transaction

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Arnaud
Posts: 3
Joined: Fri 24 Jun 2005 14:12

syntax error at end of input when opening Transaction

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

Yuri
Posts: 140
Joined: Mon 08 Nov 2004 12:07

syntax error at end of input when opening Transaction

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

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

Re: syntax error at end of input when opening Transaction

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

Yuri
Posts: 140
Joined: Mon 08 Nov 2004 12:07

syntax error at end of input when opening Transaction

Post by Yuri » Mon 26 Sep 2005 09:37

We are planning to release new version in a week.

Post Reply