Chris Kratz <chris.kratz@xxxxxxxxxxxxxx> writes: > CREATE OR REPLACE RULE debug_rule AS > ON INSERT TO test1 > do INSERT INTO test_que (row_id) > VALUES (new.id); You would be a whole lot better off doing this with a trigger. > insert into test1 > select id,data from test2 > except select id,data from test1; I believe the problem with this is that the rule re-evaluates the command to generate the "new" results, and by that point the rows have already been inserted into test1, thus disappear from the result of the "except" ... regards, tom lane
