-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/24/07 12:48, Alexander Staubo wrote: > On 5/24/07, Ron Johnson <[EMAIL PROTECTED]> wrote: >> > [2] Nobody else has this, I believe, except possibly Ingres and >> > NonStop SQL. This means you can do a "begin transaction", then issue >> > "create table", "alter table", etc. ad nauseum, and in the mean time >> > concurrent transactions will just work. Beautiful for atomically >> > upgrading a production server. Oracle, of course, commits after each >> > DDL statements. >> >> Rdb/VMS and CODASYL DBMS (both Oracle, formerly DEC, products) also >> have transactional DDL. > > Not exactly mainstream databases, and Codasyl isn't even a relational > database as far as I remember.
True, they are "legacy systems", but are still actively developed by Oracle, for Alpha and Itanium VMS. (The VAX products still are actually maintained, but only for bug-fixes.) And yes, DBMS uses the network model. (Since both it and Rdb use the same back end and on-disk structures, it's not that much extra effort to also keep on actively developing DBMS.) >> Interbase/Firebird probably also has transactional DDL. > > Apparently. I'm surprised, given how InterBase and Firebird otherwise > feel so awfully ancient. InterBase was devloped by a man who worked for DEC at the same time that Rdb was in the works. His DECisms are still apparent in Firebird. God, I'm going to hate it when we migrate to Oracle... > All right, so not unique, but very rare. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGVdNvS9HxQb37XmcRAkK4AKCxilH8XRM9es1RZ/Vma/AUrLoVnACfaGgP VSce0lLj/mw2Vj435EDEaII= =Gkbz -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/