Re: logging table changes

From: "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: logging table changes
Date: 2010-09-09 18:31:35
Message-ID: 04A6DB42D2BA534FAC77B90562A6A03D015545FF@server.rad-con.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

So far in this thread, I haven't seen anybody answer what I consider to
be a very important question about the original poster's requirements:

Why are you updating the history table????

If you update the history table, you lose old history. Instead, I think
you should be adding a new record to the history table for every
alteration made to the old one. The history table would have to contain
a field for the type of change that was made (insert, update or delete).

RobR

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma 2010-09-09 18:37:44 Re: logging table changes
Previous Message Mladen Gogala 2010-09-09 17:50:58 Re: logging table changes