Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA09191; Wed, 4 Aug 93 13:54:07 -0700
Date: Wed, 4 Aug 93 13:54:07 -0700
Message-Id: <9308042054.AA09191@postgres.Berkeley.EDU>
From: joseash@bush.cs.tamu.edu (Alfredo Sanchez)
Subject: problems with rules --and portals?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


Hello,

I defined the rule:

define rewrite rule notifier
is on append to Attributes where new.value = "movie"
do retrieve (x=notifier())\g

and it works as I expected when I append instances to
the Attributes class (which has the "name" and "value"
text attributes). The new instance is appended and
the notifier() function is called. I tried this using
the terminal monitor. However, when I run a program
using PQlib to append instances avoiding duplicates,
the rule seems to cause problems. Specifically,
the program fails to close a portal I use to get
the existing attributes. If I remove the rule, the
program works well. 

Any explanation?

Thanks in advance,

J Alfredo Sanchez H
-------------------
Hypermedia Research Lab
Texas A&M University