Re: [GENERAL] Recovering from failed transaction

2014-03-11 Thread Francisco Figueiredo Jr.
Hi Brian! I got a patch to fix this. Unfortunately, I'm having some problems with github at this moment and I couldn't push it to create a pull request. Would you mind to patch a local copy of Npgsql code and give it a try? Here is the patch: diff --git a/Npgsql/Npgsql/NpgsqlConnector.cs b/Np

Re: [GENERAL] Recovering from failed transaction

2014-03-10 Thread Brian Crowell
On Mon, Mar 10, 2014 at 4:16 PM, Jeff Janes wrote: > ... Or maybe it is mangling the "ROLLBACK;" into some form > the database doesn't recognize. Look in the postgres log files to see what > the events look like from PostgreSQL's perspective. Well that's the clue I needed. I was misinterpreting

Re: [GENERAL] Recovering from failed transaction

2014-03-10 Thread Jeff Janes
On Mon, Mar 10, 2014 at 1:41 PM, Brian Crowell wrote: > I feel dumb asking this question, but I can't seem to find the answer > online. > > I'm running serializable transactions, and so naturally, they will > sometimes fail with the error "could not serialize access due to > concurrent update." >

[GENERAL] Recovering from failed transaction

2014-03-10 Thread Brian Crowell
I feel dumb asking this question, but I can't seem to find the answer online. I'm running serializable transactions, and so naturally, they will sometimes fail with the error "could not serialize access due to concurrent update." But then I try to issue a ROLLBACK so I can continue using the conn