[SQL] Rule problem (fwd) - Mailing list pgsql-sql

From pierre@desertmoon.com
Subject [SQL] Rule problem (fwd)
Date
Msg-id 19990211144246.29596.qmail@desertmoon.com
Whole thread Raw
List 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
>
>


pgsql-sql by date:

Previous
From: "Neil Burrows"
Date:
Subject: RE: [SQL] RULE questions.
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: [SQL] RULE questions.