| From: | pierre(at)desertmoon(dot)com |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Rule problem |
| Date: | 1999-02-10 21:34:28 |
| Message-ID: | 19990210213428.4975.qmail@desertmoon.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
All,
given this rule:
create rule add_upref_os as on insert to upref_os do
update gen_stats set total = total + 1 where os_id=current.os_id;
and this insert....
insert into upref_os values(1234,2);
gives me this error continuously until I cancel the query:
NOTICE: Non-functional update, only first update is performed
NOTICE: Non-functional update, only first update is performed
NOTICE: Non-functional update, only first update is performed
I'm running 6.4. Any ideas? I've got other rules that seem to function without
issues...
-=pierre
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ricardo J.C.Coelho | 1999-02-10 21:40:27 | RES: [GENERAL] Select max field |
| Previous Message | Jan Mönnich | 1999-02-10 21:32:08 | Outer Joins |