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

ron(dot)l(dot)johnson(at)cox(dot)net (Ron Johnson) writes:

> Scott Marlowe wrote:
> [snip]
>> However, the more interesting thing here, is that every
>> statement, including DDL is transactable, except for a couple of
>> big odd ones, like create database. So, in postgresql, you can do:
>>
>> 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"?

DDL commonly hasn't been "able to be rolled back," even in "big,
expensive" databases...
--
(format nil "~S(at)~S" "cbbrowne" "cbbrowne.com")
http://www.ntlug.org/~cbbrowne/unix.html
Rules of the Evil Overlord #180. "If I ever build a device to transfer
the hero's energy into me, I will make sure it cannot operate in
reverse." <http://www.eviloverlord.com/>