[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