Re: Notes on converting from MySQL 5.0.x to PostgreSQL
От | Chris Browne |
---|---|
Тема | Re: Notes on converting from MySQL 5.0.x to PostgreSQL |
Дата | |
Msg-id | 60odwauy1p.fsf@dba2.int.libertyrms.com обсуждение исходный текст |
Ответ на | Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4 ("Jason McManus" <mcmanus.jason@gmail.com>) |
Ответы |
Re: Notes on converting from MySQL 5.0.x to PostgreSQL
|
Список | pgsql-general |
ron.l.johnson@cox.net (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 "~S@~S" "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/>
В списке pgsql-general по дате отправления: