Re: Triggers using PL/pgSQL

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