Non-Unique-Id | ... | ... | ... | Historical_flag
1             | ... | ... | ... | 0
1             | ... | ... | ... | 1
1             | ... | ... | ... | 1
2             | ... | ... | ... | 0

Insert into my_table (non-unique-id, historical_flag) values (1, 0)
> Error: Cannot insert due to rule x (...or you know..any error really....)