From: | pierre(at)desertmoon(dot)com |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | [SQL] Rule problem (fwd) |
Date: | 1999-02-11 14:42:46 |
Message-ID: | 19990211144246.29596.qmail@desertmoon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
All,
I never got any email concerning this issue. Has no one any ideas?
>
> 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 | Thomas Schoessow | 1999-02-11 14:48:48 | unsubscribe |
Previous Message | Neil Burrows | 1999-02-11 12:34:12 | RE: [SQL] RULE questions. |