From: Tomasz Myrta <jasiek@klaster.net>
To: Jamie Lawrence <postgres@jal.org>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Odd problems with create rule
Date: Fri, 25 Jul 2003 23:08:41 +0200
Message-ID: <3F219C59.2040807@klaster.net> (raw)
In-Reply-To: <20030725213836.GJ1073@jal.clueinc.net>
References: <20030725213836.GJ1073@jal.clueinc.net>
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
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: jasiek@klaster.net, postgres@jal.org
Subject: Re: Odd problems with create rule
In-Reply-To: <3F219C59.2040807@klaster.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