[Babase] Now I'm stuck in mtd_cycles
Karl O. Pinc
kop at meme.com
Wed Jan 23 13:39:37 EST 2008
On 01/23/2008 10:50:47 AM, kfenn wrote:
> Hi Karl,
>
> I'm now stuck trying to use UPLOAD to get the mtd_cycles in. I'm
> getting the following error:
>
> ERROR: insert or update on table "cycpoints" violates foreign key
> constraint "Cid on CYCLES" DETAIL: Key (cid)=(26762) is not present
> in table "cycles".
>
> I started with a whole group of cycles for Omos group but now now am
> just trying single cycles. Each time I try again, the cid number
> changes so this error doesn't seem linked to a specific
> individual...it's like it can't parse the info back into the tables
> correctly from the view, but I really don't want to have to upload
> into the tables themselves. That was the whole point of having the
> views.
> I've re-read your email advice from before (below) and read the
> documentations on the mtd_cycles view but I can't figure this out and
> I'm all out of chickens.
This was a bug in the mtd_cycles view. I expect that it's now fixed.
(Note that in babase test I accidently put in your omo2 file
sname mdate tdate ddate
ORI 2007-01-01 2007-01-16
and then had to manually remove it. Babase_test _should_ be
like it was before I started....)
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