> On Sep 13, 2024, at 10:57 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 9/13/24 07:50, Adrian Klaver wrote:
>>> On 9/13/24 02:58, Juan Rodrigo Alejandro Burgos Mella wrote:
>>> Hello, I find it unlikely that the trigger will work properly, since the reserved fields of the OLD subset have no
valuein an INSERT
>> I'm not seeing that the OP is asking for OLD.* values, they are just looking to include the result of a lookup on
anothertable in the INSERT.
>
> My mistake I see the OLD reference now.
>
>>>
Personally I would cache the lookup on the java side a send the correct value to a simple insert statement
>
>
>