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

Re: DBI driver and transactions

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>,pgsql-general(at)postgresql(dot)org
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: DBI driver and transactions
Date: 2003-02-03 03:37:47
Message-ID: 5.1.0.14.1.20030203113057.02e01850@mbox.jaring.my (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Do you want autocommit on or off?

With autocommit off, use $dbh->rollback to do ROLLBACK followed by BEGIN 
and use $dbh->commit to do COMMIT followed by BEGIN.

Don't use the $dbh->do stuff for that sort of thing.

It could be you, or could be DBI, depends on what you really want to do 
(can't tell from your message). If you are trying to catch asynchronous 
notices with autocommit off, DBI might not be a good choice.

But if you're trying to do run of the mill stuff, it's probably you :).

Link.

At 02:18 AM 2/3/03 +0000, Nigel J. Andrews wrote:
>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?



pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2003-02-03 14:02:41
Subject: Re: MOVE LAST: why?
Previous:From: Frank LeeDate: 2003-02-03 02:35:55
Subject: Re: where is the libpq++ ??

pgsql-general by date

Next:From: Lincoln YeohDate: 2003-02-03 03:42:53
Subject: Re: sorting RTL languages.
Previous:From: Greg StarkDate: 2003-02-03 03:11:36
Subject: Re: Query plan question, and a memory leak

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