[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1019
  • 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?
0
chunzi
Asked:
chunzi
1 Solution
 
ChristoferDutzCommented:
You have allready asked this and I have allready responsed ... maybe you should read the posts to your previous questions.

http://www.experts-exchange.com/Database/PostgreSQL/Q_24327529.html
0
 
ai_ja_naiCommented:
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
0
 
chunziAuthor Commented:
thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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