Germán Hüttemann Arza wrote:
Hi,I am developing a web application for auditing tables from a postgresql database.My question is: when an update occurrs in the base table, should I insert in the auditing table the new record or the old one?
Old - you already have the new version in the main table.Before you spend too long working on this though, I'd search for "audit" on www.pgfoundry.org
-- Richard Huxton Archonet Ltd