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 94A53D1C4CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 21:08:46 +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 72725-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 18:07:59 -0300 (ADT)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by svr1.postgresql.org (Postfix) with ESMTP id B316ED1C4BE
	for <pgsql-sql@postgresql.org>; Fri, 25 Jul 2003 18:08:44 -0300 (ADT)
Received: from klaster.net (core-1.citynet.pl [80.48.135.69])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 08CBB2B3CF; Fri, 25 Jul 2003 23:08:41 +0200 (CEST)
Message-ID: <3F219C59.2040807@klaster.net>
Date: Fri, 25 Jul 2003 23:08:41 +0200
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US;
 rv:1.4) Gecko/20030624
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Jamie Lawrence <postgres@jal.org>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Odd problems with create rule
References: <20030725213836.GJ1073@jal.clueinc.net>
In-Reply-To: <20030725213836.GJ1073@jal.clueinc.net>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/392
X-Sequence-Number: 14506

Dnia 2003-07-25 23:38, Użytkownik Jamie Lawrence napisał:

> 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=# 

Too many dots?
Shouldn't it be "new.project_id"?
Regards,
Tomasz Myrta