LinuxSA Mailing list archives

  From: Andrew Hill <list@fornax.net>
  To  : Carlo <carlo@active-ideas.com.au>
  Date: Wed, 14 Jun 2000 10:12:32 -0400

Re: Postgresql vs MySQL

Carlo wrote:
> 
> This is from the Mysql Reference Manual 7.23 LOCK TABLES/UNLOCK TABLES
> syntax(in part):
> 
> Normally, you don't have to lock tables, as all single UPDATE
> statements are atomic; no other thread can interfere with any

... and thus the problem when you don't have transaction support - you
can't do an update that required multiple UPDATE commands without having
to lock the tables.

Besides, transactions make it so much nicer when you get to the end of
10+ update/insert/delete/whatever commands, and something fails/changes,
and all you have to do is rollback to get back to where you started
from....

Cheers,

-- 

Andrew Hill

-- 
LinuxSA WWW: http://www.linuxsa.org.au/  IRC: #linuxsa on irc.linux.org.au
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject