[EMAIL PROTECTED] (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 "[EMAIL PROTECTED]" "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/> ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
