4 ms·
I encourage you to read my comment again, and point out where I mentioned merely setting a delete flag. Any reader worth their salt will point out that it’s not
by yzmtf2008 8y ago
I encourage you to read my comment again, and point out where I mentioned merely setting a delete flag. Any reader worth their salt will point out that it’s not what I suggested at all.
- 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.
- alexbecker 8y agoI believe the confusion is around your statement "mark every sensitive field". I think you mean "overwrite every sensitive field", but that definitely took a re-reading to infer, and I'm still not 100% sure.
- yzmtf2008 8y agoThanks, the processs reminded me of the “redaction” process, so I used mark. That’s definitely on me. Clarified.