Skip site navigation (1) Skip section navigation (2)

Re: Problems with DBI transaction handling

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Problems with DBI transaction handling
Date: 2003-02-06 21:45:10
Message-ID: Pine.LNX.4.21.0302062140310.10564-100000@ponder.fairway2k.co.uk (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-interfaces by date

Next:From: Hans-Jürgen SchönigDate: 2003-02-06 23:06:20
Subject: Re: Problems with DBI transaction handling
Previous:From: Rudy LippanDate: 2003-02-06 21:36:48
Subject: Re: Problems with DBI transaction handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group