[Babase] Queries that run forever
Lacey Maryott
lacey.maryott at duke.edu
Wed Apr 4 09:04:25 EDT 2007
Tyler,
I'm not sure what your schedule is like, but if you did want me to
show you how to Kill stuff in ppa, i have the password and I can run you
through it really quickly. I'm in Susan's lab. I will be here today
until 630, tomorrow 8-6 and friday until noon. Just let me know!
Lacey
Tyler Brock wrote:
> 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
>
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
--
Lacey Maryott
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
More information about the Babase
mailing list