RE: MySQL Transaction Problem

2001-11-09 Thread David Woods
AM To: 'Paul DuBois' Cc: [EMAIL PROTECTED] Subject: RE: MySQL Transaction Problem I'm sorry, but apparently I'm too green to be able to figure this out. You are right, when I do the SHOW CREATE TABLE, it tells me my table is MyISAM. If I use ALTER TABLE Episode TYPE=BDB;, it

RE: MySQL Transaction Problem

2001-11-09 Thread David Woods
I'm sorry, but apparently I'm too green to be able to figure this out. You are right, when I do the SHOW CREATE TABLE, it tells me my table is MyISAM. If I use ALTER TABLE Episode TYPE=BDB;, it accepts the command but does not change the table type. I am using MySQLD-max-nt, which the manual sa

Re: MySQL Transaction Problem

2001-11-08 Thread Paul DuBois
>I am writing a system that requires transactions. I understand that I need >to use Transaction-safe tables, such as BDB or InnoDB, but even when I do, I >get an error when I try to roll back my transaction. > >Here is some SQL that illustrates my problem: > >I create a table of type BDB (failure

RE: MySQL transaction problem (Again...)

2001-01-11 Thread Mehalick, Richard RE SSI-GRAX
SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Tomi Junnila [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 12:59 AM To: '[EMAIL PROTECTED]' Subject:

Re: MySQL transaction problem (Again...)

2001-01-10 Thread Tomi Junnila
* Carfield Yim <[EMAIL PROTECTED]> wrote on 11.01.01 06:19: > MySQL 3.23.29 or 3.23.30, with RedHat Linux 7.0, compile from tarball > source, can't rollback. > > Do you mean that it is platform?? There are errors build with RedHat 7.0? Hmm. It certainly does seem so as there have been a few repo

Re: MySQL transaction problem (Again...)

2001-01-10 Thread Carfield Yim
MySQL 3.23.29 or 3.23.30, with RedHat Linux 7.0, compile from tarball source, can't rollback. Do you mean that it is platform?? There are errors build with RedHat 7.0? On Wed, 10 Jan 2001, goEbusiness.com Mail Lists wrote: > MySQL 3.23.29a-gamma > Solaris 7 > > No problems here. > > On Wed, 27