[Babase] Re: new babase
Leah Gerber
lgerber at duke.edu
Mon Mar 13 11:28:54 EST 2006
>> Thanks. That cuts out a lot of errors. It almost looks manageable now
>> :). The following error seems like it might be a coding problem. I
>> can't figure out what else would be causing the error. The majority
>> of the errors look like this one.
>>
>> psql:<stdin>:897: ERROR: insert or update on table "allmiscs"
>> violates foreign key constraint "Sid on SAMPLES"
>>
>> DETAIL: Key (sid)=(12662) is not present in table "samples".
>
> Could you double check the data on foxpro for me and be sure
> that the keys in adlibs relate to rows in samples?
>
Karl,
I queried adlibs and samples in Foxpro. Every row in adlibs has a
corresponding row in samples, without exception. These are related by sid.
Leah
More information about the Babase
mailing list