-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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"? - -- 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 iD8DBQFEpUGPS9HxQb37XmcRAiJwAJ9/A/N/OgmslveSsX3Xym2QnDQz1gCghPD0 YX882Kv81hzZ4AKjaIVKHg8= =Gsml -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
