Re: new.id has wrong value in INSERT RULE - Mailing list pgsql-general

"Ian McFarland" <ian@lightershade.com> writes:
> CREATE RULE table_b_insert_rule  AS ON INSERT TO table_b
>     DO (UPDATE table_b SET active = 'f', yield = new.id WHERE table_a_id
> = new.table_a_id AND id != new.id;);

Rules are macros.  Since what is substituted for new.id in this case is
a nextval() call, you have a multiple-evaluation problem.  The above is
a pretty horrid way to do things anyway --- you should probably be using
a trigger instead.

            regards, tom lane