Odd problems with create rule

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