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

Posted on 2009-04-16
Last Modified: 2012-06-21
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?
Question by:chunzi
    LVL 20

    Accepted Solution

    You have allready asked this and I have allready responsed ... maybe you should read the posts to your previous questions.
    LVL 16

    Expert Comment

    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

    Author Closing Comment


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    MySQL going to sleep 4 58
    AWS linux AMI 3 44
    Zenoss 2 42
    Linux Script to remove files on specific directories with exclusions 19 38
    This is the error message I got (CODE) Error caused by incompatible libmp3lame 3.98-2 with ffmpeg I've googled this error message and found out sometimes it attaches this note "can be treated with downgrade libmp3lame to version 3.97 or 3.98" …
    I am a long time windows user and for me it is normal to have spaces in directory and file names. Changing to Linux I found myself frustrated when I moved my windows data over to my new Linux computer. The problem occurs when at the command line.…
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now