| From: | Jules Bean <jules(at)jellybean(dot)co(dot)uk> |
|---|---|
| To: | "Campbell, Scott" <scampbell1(at)mtt(dot)ca> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: problems with transactions |
| Date: | 2000-08-31 13:41:07 |
| Message-ID: | 20000831144107.N24680@grommit.office.vi.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-08-31 14:15:50 | Re: Error with tcp/ip networking |
| Previous Message | Pablo Prieto | 2000-08-31 13:19:46 | Error installing ODBC in NT |