Thad, ----- Original Message ----- From: "Thad Humphries" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, December 30, 2002 4:09 PM Subject: nested transactions?
> Any word when/if MySQL might support nested transactions? I have a large > Oracle ESQL application (36K lines) that I wish to port to an open source > database. This application makes frequent use of nested > transactions--writing to the log, updating other records based on the > present cursor, etc.--which is not supported by MySQL or PostgreSQL. It I think Oracle does not have nested transactions but does have savepoints? Transaction savepoints are already implemented internally inside InnoDB. The MySQL support for the syntax might come around August 2003. If someone is willing to sponsor the implementation, they may come quicker. > is supported by Firebird (http://firebird.sourceforge.net/) but Firebird > is a lot more work to program. > -- > ------------------------------------------------------------------------ > Thad Humphries "...no religious test shall ever be required > Web Development Manager as a qualification to any office or public > Phone: 540/675-3015, x225 trust under the United States." -Article VI Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php