Use an after inset trigger.
Well I did the reverse, an after delete trigger on the live table which inserts the deleted row in the history table, and it works very well.
Thanks.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
