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

DBI driver and transactions

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: DBI driver and transactions
Date: 2003-02-03 02:18:11
Message-ID: Pine.LNX.4.21.0302030155580.20150-100000@ponder.fairway2k.co.uk (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
I'm getting very odd behaviour and am getting quite frustrated at fighting this
thing. So just so I know for the future does anyone know if there are problems
with using transactions when using cached dbi handles?

I was using my own caching of the handle(s) but I didn't have time to work out
who, what, why and where someone was disconnecting it so switched to the DBI
caching connect. Note, this is NOT persistent/pooled connections.

However, either there is something wrong (and it's been fixed since I loaded
the software) or I completely fail to grasp the concept of transactions as
understood by DBI. 

With AutoCommit => 0 I see a BEGIN logged right before the
first query I send...

Oh I give up. Trying to clarify what happens when I'm now seeing rollbacks
issued in AutoCommit => mode where I'm not doing any and it's certainly not me
since I've got a trap on my interface layer to DBI for that and it's not been
tripped at all.

So, 

a) anyone know of any problems,

b) can I assume it is me and not just give up on this DBI stuff in the future (
I haven't got the time to rewrite my application now; not that I can't see it
being a particularly onerous task for what I use from DBI )

c) can I just issue BEGIN, COMMIT, ROLLBACK when I want to via normal
$dbh->do(...) without causing myself even more problems?

and
d) I've said it before but what's the point of DBI if it's not to make life
easier?


This on a linux debian potato with:

Pg      7.2.3
Perl    5.8.0
DBI     1.30
DBD::Pg 1.13


-- 
Nigel J. Andrews


Responses

pgsql-interfaces by date

Next:From: Frank LeeDate: 2003-02-03 02:35:55
Subject: Re: where is the libpq++ ??
Previous:From: Ben BorgerDate: 2003-02-01 00:47:20
Subject: Apache child processes making multiple persistent database connections via Apache::DBI

pgsql-general by date

Next:From: Greg StarkDate: 2003-02-03 03:11:36
Subject: Re: Query plan question, and a memory leak
Previous:From: Alan GutierrezDate: 2003-02-03 01:09:18
Subject: Re: History

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