On Wed, Mar 28, 2001 at 09:26:38PM +0100, Robin Szemeti wrote:
> (my pseudo-transaction scheme for MySQL is basically : .. do this and
> return a closure to undo it if I to .. bung the closures in an array ..
> if something screws up then back it all off by walking along the array
> and executing the closures ... its not rocket science but it works ..
> sort of .. I used it for doing multiple inserts into a spread of tables
I did something similar. It worked too, until not only did an insert
fail, but when I was backing out, a delete failed too. There was much
head-scratching. A week later, the hard disk died and the head-scratching
stopped.
Unfortunately, if you implement this sort of thing, mysql loses it's only
advantage over other databases - speed. But I wasn't allowed to upgrade
to (eg) postgresql for silly reasons which I forget now.
--
David Cantrell | [EMAIL PROTECTED] | http://www.cantrell.org.uk/david/
This is a signature. There are many like it but this one is mine.
** I read encrypted mail first, so encrypt if your message is important **
PGP signature