Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by hub.org (8.10.1/8.11.0) with ESMTP id e9QBrCU41649 for ; Thu, 26 Oct 2000 07:53:12 -0400 (EDT) (envelope-from jliang@ipinc.com) Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id BAA89103 for ; Thu, 26 Oct 2000 01:39:59 GMT (envelope-from jliang@ipinc.com) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id WAA79582; Wed, 25 Oct 2000 22:33:23 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39F7C0C3.FEE1D406@ipinc.com> Date: Wed, 25 Oct 2000 22:27:31 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: Clayton Cottingham CC: Chris Reynolds , pgsql-sql@postgresql.org Subject: Re: How to call a shell command in rule References: <20001024132108.A2092@s2.enthdimension.com.au> <39F71C10.FCA59A38@ipinc.com> <20001025231623.6342D2185@klay.imc> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/237 X-Sequence-Number: 1904 Hi, but perl cannot be used in trigger yet :-( Clayton Cottingham wrote: > 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 > > > > > > > > > > -- 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