> > insert into xxxx_log select * from xxxx where keyfield = NEW.keyfield; Oops, that should be OLD.keyfield. -- Mike Nolan ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)