[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