• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 939
  • Last Modified:

postgres ERROR: null value in column ""xxxxx"" violates not-null constraint

I found the following message within syslog.

< message >
postgres ERROR:  null value in column ""xxxxx"" violates not-null constraint

Note: ""xxxxx"" is masked.

I am not developer but manage server.
Would you please tell me the meaning and the solution?
1 Solution
Here you are propably inserting or updating a table and are setting a column to a null (empty) value that is defined to not be allowed to be null. When using inserts, you are propably not specifying all columns.
(I belive that crossposting is forbidden, but for clarity's sake I rewrite here the solution I gave on the other post)

simply, a null value has been inserted in a column that forbids null value inserts.
You may have an error in some inserts.
You can manually modify it by issuing an update in the db

UPDATE tablename SET columnname = yournewvalue WHERE conditionblablabla

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now