Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 69619476B57 for ; Fri, 11 Oct 2002 11:07:35 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id EB359476B52 for ; Fri, 11 Oct 2002 11:07:33 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g9BFJcx29070; Fri, 11 Oct 2002 18:19:38 +0300 Date: Fri, 11 Oct 2002 18:19:38 +0300 (EEST) From: Achilleus Mantzios To: Richard Huxton Cc: Stian Riis , Subject: Re: triggers In-Reply-To: <200210111519.06516.dev@archonet.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/142 X-Sequence-Number: 9859 On Fri, 11 Oct 2002, Richard Huxton wrote: > > The customary way is to have a "helper" process that sits there LISTENing for > a NOTICE and then calls the external program as required. Cleaner and means > the other program doesn't have any direct connection to the Postgresql > backend. > > - Richard Huxton Yet another cool feature (ala java listeners) of postgresql. P.S. Is the word "thank you" too difficult to be written by people posting and reading?? If anything else, a "thank you" is a motive. ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr