in reply to Re^5: [OT] MySQL recalibrating a sort-index
in thread [OT] MySQL recalibrating a sort-index

> Ah, you were looking for a DEFERRABLE CONSTRAINT, which postpones the constraint

Yeah this would be nice.

> I can't imagine MariaDB does not have this functionality ....

And no it doesn't.

https://stackoverflow.com/questions/5014700/in-mysql-can-i-defer-referential-integrity-checks-until-commit

Though REPLACE turns out to be a workaround, I'm glad that performance is no issue in my case.

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)
Wikisyntax for the Monastery

  • Comment on Re^6: [OT] MySQL recalibrating a sort-index