[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