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

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

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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://112905]
help
Chatterbox?
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
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (71 votes). Check out past polls.

    Notices?