[Babase] Re: demog_census null status error

Karl O. Pinc kop at meme.com
Tue Feb 19 12:58:23 EST 2008


On 02/19/2008 11:52:37 AM, Karl O. Pinc wrote:
>> kfenn wrote:

>>> I've done more diagnostic tests to try and back up my  
>>> unsubstantiated claim from yesterday that the the upload problem  
>>> for the DEMOG_CENSUS view lies with any records that do not have  
>>> the same group and reference number.  I have limited my demog  
>>> uploads to include only these records with a match between the two  
>>> columns and they all upload just fine...but I can't upload any  
>>> individuals who were alone (grp 10) or any who have a mismatch  
>>> between the grp and the reference number.  I always get the same  
>>> vague error message:
>>> 
>>> ERROR: null value in column "status" violates not-null constraint.

FYI, the problem occurred when the Status column was not given a value
in the upload.  Since the Status should always be 'D' the fix was to
have the view default the column's value to 'D'.  (You could also have
added a Status column to your upload, that was always 'D'.  But why?)

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list