Will I experience any nasty shocks moving Django from Postgres to MySQL?

If I'm developing a Django site with Postgres and intend to deploy to MySQL, am I in for any nasty surprises?

Yes, I have read this question! Some answers concerned the lack of t开发者_如何学运维ype and constraint safety in SQLite. As I understand it, Postgres exceeds MySQL in strictness and correctness. The potential issues that I can think of aren't an issue in this case.

I've done this and one big headache I came across was case sensitivity. MySQL wasn't case sensitive, Postgres was. When I ported across my data (I used fixtures) I ran into issues with django-tagging thinking it had duplicate tags. I had to hack it up to fix but in retrospect I should have just stuck with the same database.

One problem I had was that MySQL doesn't support rolling back DDL changes.
Of course it may not be a problem for you :)