Re: Notes on converting from MySQL 5.0.x to PostgreSQL - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Date
Msg-id 44A544EE.6080709@magproductions.nl
Whole thread Raw
In response to Re: Notes on converting from MySQL 5.0.x to PostgreSQL  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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 //

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: limit results to one row per foreign object
Next
From: Tom Lane
Date:
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL