News for hackers. Stuff that matters.

A comment on Why PostgreSQL is better than MySQL. Parent comment

Re:Why PostgreSQL is better than MySQL by h2so4 on Sunday October 15, 2017 @02:55PM (#15478592)
Are you sure mysql doesn't enforce foreign key constraints? I recently did a project with mysql backend and it did threw constraint errors on invalid inputs that didn't match a parent key record.
[ Parent | on HN ]
Re:Why PostgreSQL is better than MySQL by wolph on Sunday October 15, 2017 @02:57PM (#15478606)
You're partially correct. It does when inserting or updating, but if you do an alter ignore table you can create foreign key constraints that are actually invalid.

So... not in all cases

[ Parent | on HN ]