X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B8263D1B8BC for ; Tue, 6 Apr 2004 00:25:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56401-05 for ; Mon, 5 Apr 2004 21:26:20 -0300 (ADT) Received: from jimsun.LinxNet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id E6AA4D1B560 for ; Mon, 5 Apr 2004 21:25:46 -0300 (ADT) Received: by jimsun.LinxNet.com (Postfix, from userid 332) id 39A314307; Mon, 5 Apr 2004 20:26:29 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: Frequent 'deadlock detected' in 7.4 ... or just my bad X-Sun-Charset: US-ASCII Reply-To: pgsql-admin@postgresql.org In-Reply-To: <20040405151122.C79409@ganymede.hub.org> Message-Id: <20040406002629.39A314307@jimsun.LinxNet.com> Date: Mon, 5 Apr 2004 20:26:29 -0400 (EDT) From: jseymour@LinxNet.com (Jim Seymour) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/79 X-Sequence-Number: 13052 "Marc G. Fournier" wrote: > > On Mon, 5 Apr 2004, Tom Lane wrote: > > > "Marc G. Fournier" writes: > > > D'oh ... just tested my assumption, it was wrong ... *sigh* okay, back > > > to the drawing board on the code ... > > > > Can't you just change > > > > >> foreach $company_id ( keys %traffic ) { > > > > to > > > > >> foreach $company_id ( sort keys %traffic ) { > > > > etc. > > Ya, just saw the note from Matt on that also ... didn't realize it was > *that* simple ... was going to look into using the NULL Berkeley DB driver > ... the O'Reilly Programming Perl book that I have,... [snip] Kind of OT for this mailing list but... What you just ran into is why I recommend to *anybody*, even the most experienced of designers/engineers/coders/what-have-you, that they start with "Learning Perl." (Also an O'Reilly book.) Saves no end of grief ;). IMO, "Programming Perl" is mainly useful after you already have a good handle on the language. Jim