Timeline for Enforce NOT NULL for set of columns with a CHECK constraint only for new rows
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 3, 2016 at 21:56 | comment | added | user83914 | @a_horse_with_no_name will I be able to VALIDATE the constraint in the future? To do that I'll have to insert values on the existenced null values, am I right? | |
| Feb 3, 2016 at 19:56 | comment | added | David Jacobsen | One potential pitfall that I see here is if you intend for that column to remain null for existing rows going forward, then you can't ever update any of their other columns either. | |
| Feb 3, 2016 at 10:34 | history | answered | user1822 | CC BY-SA 3.0 |