Re: Triggers using PL/pgSQL

[George Weaver <gweaver(at)shaw(dot)ca>]

----- 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