From: Jamie Lawrence <postgres@jal.org>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Odd problems with create rule
Date: Fri, 25 Jul 2003 16:38:36 -0500
Message-ID: <20030725213836.GJ1073@jal.clueinc.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgres@jal.org
Subject: Re: Odd problems with create rule
In-Reply-To: <20030725213836.GJ1073@jal.clueinc.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox