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