Re: Trouble with NEW

On 07/19/2012 11:26 AM, David Johnston wrote:
>>
>> 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...". 

I think there is:)
If you have a FK between the table you have the trigger on a table you
want to update you already have the NEW or OLD values in the trigger
table with which to find the appropriate record in the other table. This
covers the OP case. Without a FK you have to create your own relationship.

>
> David J.
>
>


--
Adrian Klaver
adrian.klaver@gmail.com