http://www.perlmonks.org?node_id=112905


in reply to DBI: table locking

I believe MySQL does not support transactions. I heard PostgreSQL does have transactions, and it was discussed it in PM, I believe. Super Search? I am struggling with Oracle... HTH

pmas
To make errors is human. But to make million errors per second, you need a computer.

Replies are listed 'Best First'.
Re: Re: DBI: table locking
by broquaint (Abbot) on Sep 17, 2001 at 21:25 UTC
    MySQL does indeed support transactions but it requires you use the right table type (preferably BDB or InnoDB). So you may have to do some re-compilation/installation before you can get transactions working, but they're definitely there.
    HTH

    broquaint

Re: Re: DBI: table locking
by George_Sherston (Vicar) on Sep 17, 2001 at 21:08 UTC
    Glad to hear it's not just me. The version of MySQL I have, which is quite recent, certainly doesn't support transactions.

    § George Sherston