[Babase] Queries that run forever
Tyler Brock
tjb13 at duke.edu
Wed Apr 4 01:07:25 EDT 2007
awesome, I'll make the changes you suggested and see what happens,
can you let me know what your up to and if you change things / when i
should try again.
-Tyler
On Apr 4, 2007, at 1:03 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.
>
> Let me see about fixing this.....
>
> (FYI, sometimes the optimiser does not work so well
> when the datatypes don't match up. That's a reason
> to _not_ put numbers in quotes (unless they're going
> into a text column -- which is why I tell people
> to always put stuff in quotes so they don't have to think
> about it.))
>
> 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