Start Free Trial

asked on

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?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

(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