[Babase] Re: demog_census null status error

kfenn kfenn at princeton.edu
Tue Feb 19 13:26:43 EST 2008


Thanks Karl.  I will test this as soon as I get the chance.
Any ideas why it worked for some of the data (when grp and reference 
matched AND the group was in the census) but not for other data?


Tabby

Karl O. Pinc wrote:
>
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list