PostgreSQL provides a sample trigger timetravel which can be used to log all changes to a database row. Two columns must be added to any table which should use this feature: start_date and stop_date. Additionaly three more columns can be used to log the login name of the user inserting, updating or deleting a row. Continue reading “PostgreSQL timetravel.c patch” »