pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: Odd problems with create rule 3+ messages / 2 participants [nested] [flat]
* Odd problems with create rule @ 2003-07-25 21:38 Jamie Lawrence <postgres@jal.org> 2003-07-25 21:08 ` Re: Odd problems with create rule Tomasz Myrta <jasiek@klaster.net> 0 siblings, 1 reply; 3+ messages in thread From: Jamie Lawrence @ 2003-07-25 21:38 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Odd problems with create rule 2003-07-25 21:38 Odd problems with create rule Jamie Lawrence <postgres@jal.org> @ 2003-07-25 21:08 ` Tomasz Myrta <jasiek@klaster.net> 2003-07-25 22:08 ` Re: Odd problems with create rule Jamie Lawrence <postgres@jal.org> 0 siblings, 1 reply; 3+ messages in thread From: Tomasz Myrta @ 2003-07-25 21:08 UTC (permalink / raw) To: Jamie Lawrence <postgres@jal.org>; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Odd problems with create rule 2003-07-25 21:38 Odd problems with create rule Jamie Lawrence <postgres@jal.org> 2003-07-25 21:08 ` Re: Odd problems with create rule Tomasz Myrta <jasiek@klaster.net> @ 2003-07-25 22:08 ` Jamie Lawrence <postgres@jal.org> 0 siblings, 0 replies; 3+ messages in thread From: Jamie Lawrence @ 2003-07-25 22:08 UTC (permalink / raw) To: Tomasz Myrta <jasiek@klaster.net>; +Cc: pgsql-sql On Fri, 25 Jul 2003, Tomasz Myrta wrote: > Dnia 2003-07-25 23:38, U?ytkownik Jamie Lawrence napisa?: > >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"? Oh, god. I'm a moron, or at least should have my vision checked. Thank you. -j > Regards, > Tomasz Myrta -- Jamie Lawrence jal@jal.org Americans will tolerate just about anything as long as you don't stop traffic. - Dan Rather ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-07-25 22:08 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-07-25 21:38 Odd problems with create rule Jamie Lawrence <postgres@jal.org> 2003-07-25 21:08 ` Tomasz Myrta <jasiek@klaster.net> 2003-07-25 22:08 ` Jamie Lawrence <postgres@jal.org>
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