Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by hub.org (8.10.1/8.11.0) with ESMTP id e9PNomN19233 for ; Wed, 25 Oct 2000 19:50:49 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: from klay.imc ([216.18.11.61]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id TAA86502 for ; Wed, 25 Oct 2000 19:03:04 GMT (envelope-from drfrog@smartt.com) Received: from klay.imc (localhost.localdomain [127.0.0.1]) by klay.imc (Postfix) with SMTP id 6342D2185; Wed, 25 Oct 2000 16:16:23 -0700 (PDT) Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: binary Mime-Version: 1.0 From: Clayton Cottingham To: "Chris Reynolds" Cc: pgsql-sql@postgresql.org Reply-To: Clayton Cottingham Subject: Re: How to call a shell command in rule X-Mailer: Pronto v2.0.1 Date: 25 Oct 2000 16:16:21 PDT In-Reply-To: <39F71C10.FCA59A38@ipinc.com> References: <20001024132108.A2092@s2.enthdimension.com.au> <39F71C10.FCA59A38@ipinc.com> Message-Id: <20001025231623.6342D2185@klay.imc> X-Archive-Number: 200010/226 X-Sequence-Number: 1890 On Wed, 25 Oct 2000 10:44:48 -0700, Jie Liang said: > Hi, > > I want send a e-mail when the rows of mytable reaches 100,000, how? > > > one way is to make a function using perl and use say mail::sender as the module to send the info use the code snippet in perldoc Mail::Sender another would be to build a cron perl job that would run every so often and check out how many rows then send email > -- > Jie LIANG > > Internet Products Inc. > > 10350 Science Center Drive > Suite 100, San Diego, CA 92121 > Office:(858)320-4873 > > jliang@ipinc.com > www.ipinc.com > > > > >