Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Re: DBI: table locking

by pmas (Hermit)
on Sep 17, 2001 at 21:02 UTC ( #112905=note: print w/replies, xml ) Need Help??

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

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.


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

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://112905]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2022-05-18 14:22 GMT
Find Nodes?
    Voting Booth?
    Do you prefer to work remotely?

    Results (71 votes). Check out past polls.