Re: nested transactions
TO [EMAIL PROTECTED] wrote: Does INNODB support nested transactions? If so, what version? No, InnoDB doesn't support nested transactions. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: nested transactions
Egor Egorov [EMAIL PROTECTED] wrote: TO [EMAIL PROTECTED] wrote: Does INNODB support nested transactions? If so, what version? No, InnoDB doesn't support nested transactions. Well, not really. I've forgot to mention the savepoints: http://www.mysql.com/doc/en/Savepoints.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nested transactions
Does INNODB support nested transactions? If so, what version? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: nested transactions?
Heikki Tuuri wrote: 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. For the sake of those with more programming time than money, what kind of theoretical work is required to allow nested transactions? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Re: nested transactions?
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, x225trust 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