3 ms·
"you could easily not switch to a CASCADE, but instead set delete=1 and mark every sensitive field with a special value"
by codexon 8y ago
"you could easily not switch to a CASCADE, but instead set delete=1 and mark every sensitive field with a special value"
- dbpatterson 8y agoyou ignored "and mark every sensitive field with a special value", which is the key part. As long as all sensitive data has been essentially zero'd out (for some value of zero), all is fine.
- codexon 8y agoMarking a field sounds to me like labeling and not zeroing it out.
- jachee 8y agoWhat if "a special value" == NULL?
- namibj 8y agoIf you choose that value, and it's the only, or one of the few values that break your software, then it's your fault.