Hello all, On Thu, 19 Apr 2007 09:27:33 -0400 Kenneth Downs <ken@xxxxxxxxxx> wrote: > Ask the question: can I make sure I always have a complete trail? If > you insert the old row, you will always have the old values and the > table itself holds the new values. In tablelog (http://pgfoundry.org/projects/tablelog/) i decided to have both rows, the old and the new one. So i don't need to lookup the current state in the original table and be able to fetch any data from one single audit table. > Germán Hüttemann Arza wrote: Your quoting ... well, sucks ;-) Kind regards -- Andreas 'ads' Scherbaum Deutsche PostgreSQL Usergroup: http://www.pgug.de DPWN: http://ads.wars-nicht.de/blog/categories/18-PWN