[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