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

[Alban Hertroys <alban(at)magproductions(dot)nl>]

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 //