Re: Manual query vs trigger during data load

Rob Sargent <robjsargent@gmail.com>

From: Rob Sargent <robjsargent@gmail.com>

To: Adrian Klaver <adrian.klaver@aklaver.com>

Cc: Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>, yudhi s <learnerdatabase99@gmail.com>, pgsql-general <pgsql-general@lists.postgresql.org>

Date: 2024-09-13T17:22:53Z

Lists: pgsql-general


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

> 
> 
>