[Babase] Queries that run forever

Tyler Brock tjb13 at duke.edu
Wed Apr 4 00:43:25 EDT 2007


ok awesome yes it looks like rnktypes is in order now, I'm looking  
into why the insert doesn't work but they all used to work fine as I  
had said, I have no idea why this would change, here is another example:

INSERT INTO ranks VALUES (nextval('ranks_rnkid_seq'::regclass),  
'ALI', '1984-1-01', '1.0', 'ADF', '1');

Please let me know if you find anything or if you have any ideas, its  
a pretty simple update of one tuple, it shouldn't take too long. I  
just tried to do do an explain analyze on that query and it doesn't  
work either, it just sits there.

-Tyler


On Apr 4, 2007, at 12:38 AM, Karl O. Pinc wrote:

>
> On 04/03/2007 11:24:01 PM, Tyler Brock wrote:
>> Ok, so I'm still trying to figure out why the following query runs  
>> forever:
>> delete from rnktypes where rnktype = 'ADFFIX';
>
> FYI, I just killed a bunch of your connections
> that must have been from your java app.
>
>
> 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