Return-Path: postman 
Delivery-Date: Sun, 29 Aug 93 21:58:26 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA13065; Sun, 29 Aug 93 21:56:09 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308300456.AA13065@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: att!iwtqg!kca@ucbvax.Berkeley.EDU
Received: from ucbvax.Berkeley.EDU by postgres.Berkeley.EDU (5.61/1.29)
	id AA13057; Sun, 29 Aug 93 21:56:04 -0700
Received: from att.UUCP by ucbvax.Berkeley.EDU (5.63/1.43)
	id AA03428; Sun, 29 Aug 93 21:55:37 -0700
Message-Id: <9308300455.AA03428@ucbvax.Berkeley.EDU>
Subject: error in rules?
To: postgres@postgres.berkeley.edu (Postgres Mailing List)
Date: Sun, 29 Aug 93 23:50:21 CDT
From: Kent Archie <kca@iwtqg.Berkeley.EDU>
X-Mailer: ELM [version 2.3 PL11]
Resent-To: postgres-dist
Resent-Date: Sun, 29 Aug 93 21:56:08 PDT

I am using Postgres 4.1 with the pre-compiled binaries for the Sun under
SunOS 4.1.3.

I create a rule like this.

define rule addfile2 is
on append to amt_files
do append amt_version(file_id = new.file_id,amt_table = "struct_tree",ver_num=0)
\g

After appending to amt_files, the amt_version table is empty.
It appears the rule did not fire.

I attempt to remove the rule and re-do it but:

ginko>monitor -c"remove rule addfile2" amt
WARN:Aug 29 23:36:14:prs2GetRuleEventRel: class 20816 not found

I then add the rule again anyway and get:

*
Query sent to backend is "define rule addfile2 is  on append to amt_files do app
end amt_version(file_id = new.file_id,amt_table = "struct_tree",ver_num=0)"
WARN:Aug 29 23:31:17:Sorry, rule addfile2 is already defined

This stuff worked earlier this month or so, on this version of Postgres.
Or at least it appeared to.
Any suggestions?
**kent
Kent Archie
kca@iwtqg.att.com