Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA04675 for postgres-redist; Thu, 4 Aug 1994 12:20:26 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199408041920.MAA04675@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA04662; Thu, 4 Aug 1994 12:20:26 -0700 Message-Id: <199408041920.MAA04662@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol From: aoki@CS.Berkeley.EDU (Paul M. Aoki) To: "David Alan Nelson" Cc: postgres@postgres.Berkeley.EDU (Postgres) Subject: Re: Triggers Reply-To: aoki@CS.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Thu, 4 Aug 1994 16:47:05 +0100 (BST) Date: Thu, 04 Aug 94 12:20:25 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Thu, 04 Aug 94 12:20:26 -0700 Resent-XMts: smtp "David Alan Nelson" writes: > How do I support alerters and triggers in Postgres 4.1. I thought it > was just a case of adding the always keyword to a retrieve or replace > command don't believe any syntax or examples you see in the academic papers. syntax tended to change with the phase of the moon. depending on what you're trying to do, instance/rewrite rules may do some of what you want. see "define rule". for alerters, see "listen"/"notify" and "libpq" (under asynchronous portal). -- Paul M. Aoki | University of California at Berkeley aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776) | Berkeley, CA 94720-1776 ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================