Transactions?

[J. Paul Reed]

On 28 Jul 2003 at 09:57:47, Mark Ingram arranged the bits on my disk to say:

> is it possible todo transactions with the bugzilla code?
> 
> i want to add data into 2 tables and obviously dont want to put it into
> the 1st table and then have it fail on the second table.
> 
> im currently using SendSQL to execute database commands.

Is it possible to do transactions with Bugzilla *code*? Sure.

Is it possible to do transactions with the *database* Bugzilla uses? No.

The solution is to use another database; there are bugs for supporting
PostgreSQL (bug 98304) and Sybase (bug 173130) but both of them are in
different stages of bitrot and completion, and thus are of varying degrees
of use.

You *might* be able to get away with using MySQL 4.x, which has
commit/rollback (MySQL developers think this means they have
"transactions"), and see if you can it working that way.

There's not a real easy solution to your problem, unfortunately.

BTW, SendSQL is deprecated.

Later,
Paul
------------------------------------------------------------------------
J. Paul Reed -- 0xDF8708F8 || preed at sigkill.com || web.sigkill.com/preed
To hold on to sanity too tight is insane.   -- Nick Falzone, Pushing Tin

I use PGP; you should use PGP too... if only to piss off John Ashcroft