Matthew Burgess wrote: > On Monday 12 March 2007 20:47, Alan Lord wrote: > >> Yes there are quite a few differences between Postgresql and MySQL in >> syntax, SQL implementation (PGSQL is fully ACID compliant whereas MySQL >> is apparently not) > > MySQL is actually ACID compliant, but only if you use the InnoDB storage > engine. InnoDB is *not* the default storage engine - for some strange reason > upstream provide a default (MyISAM) that has non-ACID transactions on tables > that don't support referential integrity via foreign key constraints. Quite > how that equates to a relational database I have no idea! Personally, I use > PostgreSQL wherever possible. > > Regards, > > Matt.
Thanks for that snippet - useful to know. Cheers Alan -- http://linuxfromscratch.org/mailman/listinfo/blfs-support FAQ: http://www.linuxfromscratch.org/blfs/faq.html Unsubscribe: See the above information page