>
> 4) If you want to pull information from another table, you either need to set
> up a FOREIGN KEY relationship that you can leverage or you need to do a
> query in the trigger function that pulls in the necessary information.
>
I do not get where the "OR" comes from. There is nothing magical about FOREIGN KEY that causes NEW magically contain
additionalvalues. Foreign Key or not you still have to "...do a query in the trigger function...".
David J.