Jeff Boes <jboes(at)qtm(dot)net> writes:
> It appears that the rule is inserting the row copies into
> job_queue_trace with a job_id value that is one higher than the job_id
> from the original row. Almost as though it was re-evaluating the
> sequence ...
No kidding. A rule is a macro and therefore has the usual risks of
multiple evaluations of arguments.
The only way to do what you want is with a trigger.
regards, tom lane