Hi,

kyle is right, you can do this with triggers. You can see an example here about using Perl and PostgreSQL.

I don't know your problem domain, but you could also think about using some revision control system

Regards,