[Babase] Re: demog_census null status error

Karl O. Pinc kop at meme.com
Tue Feb 19 12:52:37 EST 2008


Tabby,

I believe I've fixed this.  Please test.

(My problem was I was thinking the Cen column was the
complaint, where the error message clearly says the problem
is in the Status column.)

On 02/08/2008 07:42:56 AM, kfenn wrote:
> This one got bounced back to me as well so I'm trying again.
> 
> 
> Tabby
> 
> kfenn wrote:
>> Hi again Karl,
>> 
>> I know we just talked, but since this email is already written, I'm  
>> going to send it for the archives in case this comes up again (or  
>> somewhere else!)
>> 
>> 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.
>> 
>> I think the ball is in your court on this one because there's no  
>> data to correct.
>> 
>> 
>> Tabby
>> 
> 
>-- 
> 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)
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 
> 

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