Out of curiosity, which "big, expensive enterprise database" are you spoiled by? Many that I support do not allow DDL within an transaction, or if they allow it, there are many caveats and rules.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson Sent: Friday, June 30, 2006 8:22 AM To: pgsql general Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL -----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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly