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