ERROR: NOT NULL constraint failed
Issue #349
duplicate
I am trying to add a new column to my table with the NOT NULL constraint, bu it gives my the following error: NOT NULL constraint failed.
Comments (3)
-
repo owner
-
repo owner
- changed status to duplicate
Duplicate of
#344. -
repo owner
- removed milestone
-
assigned issue to
phpLiteAdmin
- Log in to comment
- Assignee
- Type
- Priority
- Status
- duplicate
- Component
- ALTER TABLE
- Milestone
- –
- Version
- 1.9.7
- Votes
- 0
- Watchers
- None
You specify that a new column must have a value in a table that already has rows. These rows cannot already have values in there. So how can this constraint work out? --> You need to specify a DEFAULT value (which must not be NULL) for this column that will be assigned to the existing columns.
Please first think about your issue, then search your issue and only if both fail, post a bug report. You would have found at least issue issue #344 where someone had the exact same problem.