Page 1 of 1

LINQ => PostgreSQL & stored function

Posted: Wed 16 Mar 2011 16:19
by ChrisMH
I have a function in my PostgreSQL database that uses pl/pgsql to RAISE an error under certain conditions. In my .NET code using LINQ, I would expect that calling this function would generate some type of exception in my code that contains the error string from my RAISE command.

Instead, the call to the function times out and I get a SocketException.

Is this the expected behavior? Is there a way to get the RAISE exception to propagate back to my code?

Thanks,
Chris

Posted: Thu 17 Mar 2011 17:34
by StanislavK
Thank you for the report, we've reproduced the issue. We will investigate it and inform you about the results.

Posted: Tue 22 Mar 2011 09:25
by StanislavK
We have fixed this issue, PgSqlException should be thrown for an exception raised inside a function now. The fix will be available in the nearest build. We will post here when this build is released.

Posted: Thu 24 Mar 2011 14:35
by ChrisMH
Fixed in 2.20.17

Thanks!