CFTRANSACTION and PostgreSQL/mySQL
Hey All, I've seen many posts out there about PostgreSQL and mySQL and rollbacks.I want to know if they will properly rollback (not commit) if a query(s) fail inside a CFTRANSACTION block? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFTRANSACTION and PostgreSQL/mySQL
Bryan Stevenson wrote: I've seen many posts out there about PostgreSQL and mySQL and rollbacks.I want to know if they will properly rollback (not commit) if a query(s) fail inside a CFTRANSACTION block? PostgreSQL: yes MySQL: only if you take the provisions described in the MySQL manual Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFTRANSACTION and PostgreSQL/mySQL
Thanks Jochem ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Wednesday, October 08, 2003 11:03 AM Subject: Re: CFTRANSACTION and PostgreSQL/mySQL Bryan Stevenson wrote: I've seen many posts out there about PostgreSQL and mySQL and rollbacks.I want to know if they will properly rollback (not commit) if a query(s) fail inside a CFTRANSACTION block? PostgreSQL: yes MySQL: only if you take the provisions described in the MySQL manual Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]