----- Original Message -----
From: Aaron Bono
To: John DeSoi
<snip>
I don't think so but there was some discussion a week or two ago about
mixing variables and using execute. I am curious, does anyone >know what
the "best" approach is?
Also, I did not address deletions. If you still need to delete from the
table, you will need to get rid of the foreign key on the history table.
>You will also need to decide how the history table will reflect the
recording of those deletions.
You may want to refer to:
http://www.varlena.com/GeneralBits/104.php (Logging Audit Changes with
Composite Typed Columns).
It provides a very concise way of tracking all changes, possible qualifying
as a "best approach"?
Regards,
George
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
