Re: Notes on converting from MySQL 5.0.x to PostgreSQL

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(at)magproductions(dot)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 //