X-Original-To: pgsql-general-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 89CAA9FA163 for ; Fri, 30 Jun 2006 12:36:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62598-01 for ; Fri, 30 Jun 2006 12:36:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.magproductions.nl (magfour.magproductions.nl [87.249.97.162]) by postgresql.org (Postfix) with ESMTP id 0E1C19FA4A7 for ; Fri, 30 Jun 2006 12:36:19 -0300 (ADT) Received: from cc756500-a.ensch1.ov.home.nl ([82.75.196.246] helo=[172.27.1.3]) by mx1.magproductions.nl with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1FwL2W-00039g-8h; Fri, 30 Jun 2006 17:36:16 +0200 Message-ID: <44A544EE.6080709@magproductions.nl> Date: Fri, 30 Jun 2006 17:36:14 +0200 From: Alban Hertroys User-Agent: Mozilla Thunderbird 1.0.8 (X11/20060502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ron Johnson CC: pgsql general Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL References: <1151680333.13129.55.camel@state.g2switchworks.com> <44A5418F.8040901@cox.net> In-Reply-To: <44A5418F.8040901@cox.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/1221 X-Sequence-Number: 97593 Ron Johnson wrote: >>begin; >>create table xyz... >>alter table abc... >>insert into abc select * from iii >>update iii...; >>drop table iii; >>(oops, I messed up something) >>rollback; > > > But isn't that what it means to be "transactional"? Or am I spoiled > by my "big, expensive enterprise database"? Well, according to my colleague here this wasn't possible until now (partially!) in Oracle 10. Meaning it's not common-place even among enterprise db's. -- Alban Hertroys alban@magproductions.nl magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //