X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4E8ECD1B510 for ; Thu, 2 Oct 2003 02:52:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 71789-10 for ; Wed, 1 Oct 2003 23:52:09 -0300 (ADT) Received: from mail.messagingengine.com (out2.smtp.messagingengine.com [66.111.4.26]) by svr1.postgresql.org (Postfix) with ESMTP id 8BC30D1B522 for ; Wed, 1 Oct 2003 23:52:05 -0300 (ADT) Received: from smtp.us2.messagingengine.com (localhost [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id 62CB42533C6 for ; Wed, 1 Oct 2003 22:50:49 -0400 (EDT) Received: from 10.202.2.133 ([10.202.2.133] helo=smtp.us2.messagingengine.com) by messagingengine.com with SMTP; Wed, 01 Oct 2003 22:50:49 -0400 Received: by smtp.us2.messagingengine.com (Postfix, from userid 99) id A6A9976DFF; Wed, 1 Oct 2003 22:50:48 -0400 (EDT) Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="Big5" MIME-Version: 1.0 X-Mailer: MIME::Lite 1.2 (F2.71; T1.001; A1.51; B2.12; Q2.03) From: "CN" To: pgsql-sql@postgresql.org Date: Wed, 01 Oct 2003 18:50:48 -0800 X-Epoch: 1065063049 X-Sasl-enc: 7m+TMZSgvo8RTGpq+Ppx4w Subject: Re: help with rule and notification References: <20031002021523.96380.qmail@web41015.mail.yahoo.com> In-Reply-To: <20031002021523.96380.qmail@web41015.mail.yahoo.com> Message-Id: <20031002025048.A6A9976DFF@smtp.us2.messagingengine.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=IN_REP_TO, RCVD_IN_OSIRUSOFT_COM, REFERENCES X-Spam-Level: X-Archive-Number: 200310/21 X-Sequence-Number: 15421 > so anyone listening for notifications on table2 can > ask table2 for the jobno that was updated. then if > they were viewing that jobno, update their display. if > not just ignore the notify. Pardon me if I make your focus blur! I believe the implementation for such requirement in an application server in 3 tier environment is not too difficult. Regards, CN -- http://www.fastmail.fm - Or how I learned to stop worrying and love email again