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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group