> On Sep 13, 2024, at 10:57 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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 value in 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 another table 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 > > >
