Perl and AutoCommit

From: Madison Kelly <linux(at)alteeve(dot)com>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Perl and AutoCommit
Date: 2005-03-27 05:31:50
Message-ID: 42464546.9000004@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

After looking at the postres and perl docs plus some Googling I can't
seem to find the answer I am looking for. I hope maybe someone here can
help. ^_^

What I am trying to do is turn off autocommit for one particular task
in my program. I realize I can turn off AutoCommit when I connect to the
database but in this case that is not what I want to do. This is a
one-off task.

What I thought would work was:

$DB->begin_work() || die...
# a lot of transactions
$DB->commit() || die...

But that doesn't seem to be it, either...

Any advice would be much appreciated. Even if it's just a pointer to
the right docs with the answer that I probably missed while searching. :)

Madison

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU, The Linux Experience; Back Up
http://tle-bu.thelinuxexperience.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Sugalski 2005-03-27 05:59:02 Re: Perl and AutoCommit
Previous Message Tom Lane 2005-03-27 04:52:50 Re: 8.0.2 Beta Available