X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id D7619D1C4CC
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 20:41:17 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 73820-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 17:40:30 -0300 (ADT)
Received: from jal.clueinc.net (xd84b436b.ip.e-nt.net [216.75.67.107])
	by svr1.postgresql.org (Postfix) with ESMTP id 02517D1C4BC
	for <pgsql-sql@postgresql.org>; Fri, 25 Jul 2003 17:41:16 -0300 (ADT)
Received: from jal.clueinc.net (localhost [127.0.0.1])
	by jal.clueinc.net (8.12.9/8.12.9/Debian-5) with ESMTP id
	h6PLccA9017308
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL)
	for <pgsql-sql@postgresql.org>; Fri, 25 Jul 2003 16:38:38 -0500
Received: (from jal@localhost)
	by jal.clueinc.net (8.12.9/8.12.9/Debian-5) id h6PLcbxY017306
	for pgsql-sql@postgresql.org; Fri, 25 Jul 2003 16:38:37 -0500
Date: Fri, 25 Jul 2003 16:38:36 -0500
From: Jamie Lawrence <postgres@jal.org>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Odd problems with create rule
Message-ID: <20030725213836.GJ1073@jal.clueinc.net>
Mail-Followup-To: pgsql-sql <pgsql-sql@postgresql.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Organization: clue inc
X-URL: http://www.clueinc.net/
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/391
X-Sequence-Number: 14505


Hi all -

I'm having a strange problem creating a rule on a view.

I've done this with no problem in other databases... I'm wondering if
somehow there was something omitted or some other type of prolem with
the database creation. Or, I could have no idea what I'm talking about.

Any guesses?

dlm=# create or replace  rule addenda_insert_rule as
dlm-#         on insert to addenda do instead 
dlm(#                 insert into documents (
dlm(#                         project_id,
dlm(#                         doc_num,
dlm(#                         description,
dlm(#                         date,
dlm(#                         people_id,
dlm(#                         parent,
dlm(#                         document_type,
dlm(#                         state,
dlm(#                         machines_id,
dlm(#                         phases_id )
dlm(#                 values (
dlm(#                         new.projects._id,
dlm(#                         new.doc_num,
dlm(#                         new.description,
dlm(#                         new.date,
dlm(#                         new.people_id,
dlm(#                         new.parent,
dlm(#                         new.document_type,
dlm(#                         new.state,
dlm(#                         new.machines_id,
dlm(#                         new.phases_id );
ERROR:  Namespace "*NEW*" does not exist
dlm=# 

Thanks.

-j

-- 
Jamie Lawrence                                        jal@jal.org