Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4BB029FA18F for ; Wed, 3 Jan 2007 12:27:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 26907-06 for ; Wed, 3 Jan 2007 12:27:44 -0400 (AST) X-Greylist: delayed 00:06:40.200017 by SQLgrey-1.7.4 Received: from starfish.geekisp.com (mail.geekisp.com [216.168.135.169]) by postgresql.org (Postfix) with ESMTP id 797BB9F9312 for ; Wed, 3 Jan 2007 12:27:44 -0400 (AST) Received: (qmail 16346 invoked by uid 1003); 3 Jan 2007 16:21:03 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=redterror.net; b=fSbuvLcRdjA/NEP6QbfCUJmBp4pJQloV6BhkiybpbvobH3K6zv2CpcisjDX7tb/pM1FtkGbYGcWkva5+b1q4pdAtqsq+zH15LEfP1uB4RHSkF67F/PxcU2eJGcJJ1N5/ ; Received: from [192.168.7.100] (localhost.geekisp.com [127.0.0.1]) by localhost.geekisp.com (tmda-ofmipd) with ESMTP; Wed, 03 Jan 2007 11:20:47 -0500 (EST) Message-ID: <459BD7DF.1030807@redterror.net> Date: Wed, 03 Jan 2007 11:20:47 -0500 User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: ramachandra.bhaskaram@wipro.com CC: pgsql-sql@postgresql.org Subject: Re: [SQL NOTIFY Help] sending NOTIFY to the external program References: <47230CE166B64744B0120173E4C2161E0103E6A1@BLR-EC-MBX01.wipro.com> <20070103161021.GA8599@phlogiston.dyndns.org> In-Reply-To: <20070103161021.GA8599@phlogiston.dyndns.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Delivery-Agent: TMDA/1.0.3 (Seattle Slew) From: Dave Steinberg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/8 X-Sequence-Number: 27160 > On Wed, Jan 03, 2007 at 07:47:34PM +0530, ramachandra.bhaskaram@wipro.com wrote: >> Yes, our application is supposed to know *immediately* that a change in >> the database has occurred since, I'd recommend some sort of "whiteboard" layer or messaging fabric as an option for this sort of thing. This offloads the notification element from the database, and lets you pass along any data you want to the listeners - even the complete record. Also this sort of thing scales well to multiple listeners. Anyway, just a thought... Regards, -- Dave Steinberg http://www.geekisp.com/ http://www.steinbergcomputing.com/