Alvaro Herrera <[EMAIL PROTECTED]> writes: > Does it work if you do
> regression=# create rule r2 as on update to src do > regression-# insert into log values(old.f1, old.f2, 'old'), (new.f1, new.f2, > 'new'); No, that's not the problem. "*" expansion works just fine here, it's the executor that can't deal with the resulting Vars. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match