[Babase] Queries that run forever
Tyler Brock
tjb13 at duke.edu
Wed Apr 4 00:31:42 EDT 2007
Ok awesome! Also, this is the update query I was trying to run:
INSERT INTO ranks VALUES (nextval('ranks_rnkid_seq'::regclass),
'PLA', '2003-1-01', '10.0', 'ALM', '1');
any idea why something like this would take forever, it should work...
-Tyler
On Apr 4, 2007, at 12:30 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';
>> I thought it might be because it is referenced in ranks by some of
>> the sample stuff i created but then i ran a delete on all of those
>> rows to ensure it would not complain if adffix was deleted from
>> rnktypes. However this query still runs forever along with my
>> other update calls to the ranks table in the database which used
>> to work quickly. I have no idea why so I'm going to you guys for
>> help again.
>
> I'll take a look. I probably have something going on in the delete
> trigger. I may not care that it takes a long time because it's
> almost never that something's deleted from RNKTYPES.
>
>> Karl, thank you for the advice last time but I still have no idea
>> what the password for the admin is so I am unable to start these
>> rouge processes that have been created. Sorry.
>
> Lacey can help you out.
>
> 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