[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] problems with transactions
From:       Jules Bean <jules () jellybean ! co ! uk>
Date:       2000-08-31 13:41:07
[Download RAW message or body]

On Thu, Aug 31, 2000 at 09:43:52AM -0300, Campbell, Scott wrote:
> 
> $sth = $dbh->prepare("begin work");
> $sth->execute();
> 

[snip error]

> 
> after seeing this I assumed that you just can't use the begin statement
> accross the DBI but there has to be a way of opening a transaction (it even
> says so in the error I got) ... I'm just not sure how.
> 
> can someone please shed some light on this... I've looked through the
> archives but didn't find anything constructive. 

man DBI

Look for the section on AutoCommit, and the section on Transactions
will also be useful. One sentence summary: Make sure autocommit is
off, transactions are begun automatically, and ended with commit or
rollback.

Jules

[prev in list] [next in list] [prev in thread] [next in thread]