Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199403301421.GAA08494@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Subject: notify turned off in 4.1??
To: postgres@postgres.Berkeley.EDU
Date: Wed, 30 Mar 1994 08:54:35 -0500 (EST)
Content-Type: text
Content-Length: 1014      
From: keen@ms.uky.edu
Message-ID: <9403301354.aa27975@s.s.ms.uky.edu>
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Wed, 30 Mar 94 06:21:45 -0800
Resent-XMts: smtp


We have Postgres 4.1 installed.
There is a capability of Postgres that I could really use, notify, 
which seems to be turned off.

There is a sample program that claims to set itself asynchronously
so that when a rule is triggered in postgres, it will be 'notified'
and can proceed on its execution.  
However, when I define the rule to trigger it, it gives the output below.

Welcome to the C POSTGRES terminal monitor

Go 
* define rule r1 is on append to test1 do
[append test1a (i = new.i)
notify test1a] \g

Query sent to backend is "define rule r1 is on append to test1 do [append test1a (i = new.i) notify test1a] "
WARN:Mar 29 23:02:01:notify is turned off for 4.0.1 - see the release notes

*

So notify is turned off in version 4.0.1.  BUT the documentation
says this is version 4.1. 

Is this a mistake by the person installing the program?
I believe he used the pre-compiled binaries.
Is there a fix for it? Or is notify turned off in 4.1 also?

Thanks for any assistance,
Debby Keen
keen@ms.uky.edu