-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Chris Browne wrote: > [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...
I guess I'm just fortunate... - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEpd6BS9HxQb37XmcRAgu8AKCqp6KxNYoa0tIcmbglG8XXSzgXpQCgjDLv vYkFNzwXF1K+b9ZNK6Svr64= =mW9L -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend