X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 00D8F329EF2 for ; Sun, 17 Oct 2004 02:10:14 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04676-05 for ; Sun, 17 Oct 2004 01:10:02 +0000 (GMT) Received: from fusion.bennyvision.com (fusion.bennyvision.com [216.161.119.28]) by svr1.postgresql.org (Postfix) with SMTP id 72052329E86 for ; Sun, 17 Oct 2004 02:10:04 +0100 (BST) Received: (qmail 6133 invoked from network); 17 Oct 2004 01:10:04 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 17 Oct 2004 01:10:04 -0000 Received: from 63.227.74.41 (SquirrelMail authenticated user benny); by webmail.stinkweasel.net with HTTP; Sat, 16 Oct 2004 20:09:42 -0500 (CDT) Message-ID: <55738.63.227.74.41.1097975404.squirrel@63.227.74.41> In-Reply-To: <20041017004929.GB19149@commandprompt.com> References: <56362.63.227.74.41.1097813923.squirrel@63.227.74.41> <87hdow4ld1.fsf@stark.xeocode.com> <64883.63.227.74.41.1097846113.squirrel@63.227.74.41> <20041017004929.GB19149@commandprompt.com> Date: Sat, 16 Oct 2004 20:09:42 -0500 (CDT) Subject: Re: Inserting into table only if the row does not already From: "C. Bensend" To: pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/102 X-Sequence-Number: 19205 > Even cron'd scripts can run amok. Lock files are great as a CYA > measure even if you're relatively certain there will be no opportunity > for one copy to step on the next. Yes, you are absolutely correct, of course. :) I should be more specific - I'm working on a personal project, and I'm not going to worry about that right now. The risk of a cron gone wild is acceptable to me at this moment. Right now my priority is getting data flowing into the database instead of piling up on the host like it is. :) Thanks much! Benny -- "Even if a man chops off your hand with a sword, you still have two nice, sharp bones to stick in his eyes." -- .sig on Slashdot