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

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

Reply via email to