Re: Odd problems with create rule

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