Horton
Menu

Re: Manual query vs trigger during data load

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>, yudhi s <learnerdatabase99@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2024-09-13T14:57:28Z
Lists: pgsql-general 
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.

> 
>>
>> Atte
>> JRBN
>>
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com