Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: DBI: table locking

by pmas (Hermit)
on Sep 17, 2001 at 21:02 UTC ( [id://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

[reply]
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
[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://112905]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2024-04-24 06:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found