Re: Buglist
От | Bo Lorentsen |
---|---|
Тема | Re: Buglist |
Дата | |
Msg-id | 1061304030.1923.168.camel@localhost обсуждение исходный текст |
Ответ на | Re: Buglist (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
On Tue, 2003-08-19 at 16:03, Tom Lane wrote: > It's still bolted on. The entire concept that "transactional integrity > is optional" is ludicrous, IMHO. "Integrity" and "optional" are > contradictory. Good point. Also the problem of MyISAM and InnoDB RI :-) > One thing you should ask about MySQL is where they keep the system's > metadata (catalog data). In Postgres it's under transactional control > just like everything else, which means it's (a) crash-safe and (b) > rollback-able. This is why all DDL changes are rollback-able in PG. > I honestly don't know what the corresponding arrangements are in MySQL > ... but I suspect that even in an all-InnoDB database, there is critical > system data that is outside the InnoDB table handler and thus not > transaction-safe. Thats a really nice thing for temporary tables, but "point in time" backup is a much stonger argument :-) /BL
В списке pgsql-general по дате отправления: