avatar

SQLServerIO

Member Since: November 12, 2013

Country: United States

  • News - On Breaking Things... Aga… | about 6 months ago

    Are you guys using foreign keys at all? I have found, to my dismay, that MySQL may not honor keys even if they are enforced and you can end up with inconsistent data. Usually, I have found this out during pre-migration testing but it can be a huge PITA. I have also seen FK’s defined on the postgres side but not enforced leading to the same kind of condition. Did you have to deal with this and if so how did you handle it? For the record, I’m a MS SQL Server guy as well but really love Postgres quite a bit as well.

No public wish lists :(