[Babase] Queries that run forever
Tyler Brock
tjb13 at duke.edu
Wed Apr 4 01:53:16 EDT 2007
Karl,
I was wondering if you would be able to make the changes I made to
the rnktypes table within babase copy permanent... my program depends
on them being correct, as they are incorrect within babase test and
copy and I wish to update them. Please let me know if this is
possible, thanks for helping with all this again.
-Tyler
On Apr 4, 2007, at 1:08 AM, Karl O. Pinc wrote:
> Tyler, Everybody,
>
> On 04/04/2007 12:03:19 AM, Karl O. Pinc wrote:
>> Ah,
>> I think I see the problem.
>> I may have reloaded/changed the triggers/validation
>> in babase_copy but not changed the structure of the
>> groups table. (We went through a change in the
>> GROUPS.Permanent column a ways back.) The datatype
>> changed. This probably borked the triggers and
>> they run forever.
>
> Ok. That's definately the problem.
>
> The right way to fix it is to recreate the babase_copy
> db and restore the data. It's late right now and
> that takes a while. So, let's cheat.
>
> For now why don't you use the babase_test
> database instead of the babase_copy database.
> I'll write the list when we next do a conversion
> and fixup both babase_test and babase_copy
> and you can go back to using babase_copy.
>
> I just tried the query in babase_test and
> everything works fine. So we're good to
> go and you don't have a problem at all.
> (Unless this problem is hiding another.... ;-)
>
> Meanwhile Tabby and I are already messing up the
> babase_test database data so there's no reason
> you can't mess it up too. We _probably_
> won't interfere with each other.
>
> 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
-Tyler
Tyler J. Brock
Duke University
6202 McQueen Dr.
Durham, NC 27705
(516)857-5208
tjb13 at duke.edu
More information about the Babase
mailing list