Re: Manual query vs trigger during data load

Adrian Klaver <adrian.klaver@aklaver.com>

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:50:56Z

Lists: pgsql-general

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.

> 
> Atte
> JRBN
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com