On Tue, 4 Feb 2003, Hans-Jürgen Schönig wrote:
> Date: Tue, 04 Feb 2003 09:59:36 +0100
> From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] Problems with DBI transaction handling
> 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.
What version of DBD::Pg are you using? There was a fix put in for a bug
with failed transactions in v 1.21. From the chagelog:
Properly reset transaction status after failed transaction when
autocommit is off. Properly report transaction failure message.
> Does anybody have similar problems? This is VERY annoying and should not
I have been using 7.3 since the end of november, and I have not had any
problems with transactions, BTA this is just a development envionment.
What are you seeing? Do you have any sample code? Maybe a trace?
> The problem is: There is no other interface around providing persistent
> connections with Perl/Apache.
How are you using persistant connections?
In response to
pgsql-interfaces by date
|Next:||From: Nigel J. Andrews||Date: 2003-02-06 21:45:10|
|Subject: Re: Problems with DBI transaction handling|
|Previous:||From: Jeroen T. Vermeulen||Date: 2003-02-06 20:59:57|
|Subject: Re: how to|