Issue getting proper exception from PostgreSQL in c#

Question

I use Npgsql.dll ver. 2.2.2.0 as Data provider in my C# application and when I perform insert/update/delete operation that causes constraint violation provider raises "42601 syntax error" instead of proper exception.

The same situation is with custom exceptions from PostgreSQL functions.

However divide by zero exception is properly re-thrown by Npgsql.

How do I change such an odd behavior?

Teaman · Accepted Answer · 2014-11-26 06:27:23Z

1

The issue resolved by downgrading to Npgsql.dll ver. 1.3. Unfortunately it's not the proper solution, but it works fine at least.

answered Nov 26, 2014 at 6:27

Teaman

1877 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue getting proper exception from PostgreSQL in c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related