Re:Why HStore2/jsonb is the most important patch of PostgreS...
by jeltz on Sunday February 23, 2014 @10:53AM
(#7286209)
Not a Django guy but my guess is that it has nothing to do with South and all to do with that PostgreSQL supports transactional DDL while MySQL does not.
Re:Why HStore2/jsonb is the most important patch of PostgreS...
by raverbashing on Sunday February 23, 2014 @11:15AM
(#7286305)
True, however transactional DDL doesn't seem to be a problem after MySQL 5.5
https://wiki.postgresql.org/wiki/Transactional_DDL_in_Postgr...
Re:Why HStore2/jsonb is the most important patch of PostgreS...
by masklinn on Sunday February 23, 2014 @01:31PM
(#7286884)
This only demonstrates that rollbacking an insertion after creating a table within a transaction now works. That is, it shows DDL does not completely break a transaction it's performed in.
According to the documentation DDL remains non-transactional in MySQL 5.5[0]
> The CREATE TABLE statement in InnoDB is processed as a single transaction. This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction.
[0] http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html
So I think it's also South who's not as good in doing upgrades in MySQL as it is with PostgreSQL