Re: Problems with DBI transaction handling - Mailing list pgsql-interfaces

From Nigel J. Andrews
Subject Re: Problems with DBI transaction handling
Date
Msg-id Pine.LNX.4.21.0302062140310.10564-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Problems with DBI transaction handling  (Hans-Jürgen Schönig <hs@cybertec.at>)
List pgsql-interfaces
On Tue, 4 Feb 2003, Hans-Jürgen Schönig wrote:

> Does anybody else have problems with DBI transaction handling? Since
> PostgreSQL 7.3 (most likely) the stuff seems to be broken. Errors occur
> even if autocommit is set properly and rollbacks are not performed the
> way it should be.
>
> Does anybody have similar problems? This is VERY annoying and should not
> happen.
> The problem is: There is no other interface around providing persistent
> connections with Perl/Apache.
>
> Maybe it is worth thinking about a Perl implementation of LibEasy with
> Apache persistent connections.

Well I have wasted so much time recently, some of it spent trying to work out
what DBI was doing. However, that was my lack of knowledge, although I'm still
not convinced my tests don't now pass by luck. I'm also using a 7.2.3 server
not 7.3 yet and it's not using the mod_perl persistent connection stuff.

So in short, I'm not surprised you're having problems but unfortunately I can't
say I experienced the same problem. Perhaps you could give a small test case
that shows the problem as I'm sure DBI must have been tested against 7.3.


--
Nigel J. Andrews



pgsql-interfaces by date:

Previous
From: Rudy Lippan
Date:
Subject: Re: Problems with DBI transaction handling
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Problems with DBI transaction handling