ew.col1,new.co2new.colN)';
Execute sql;
ERROR: missing FROM-clause entry for table "new"
There is nothing wrong with the resulting code from sql because if I output
the string and put it in as static SQL in my trigger it works.
How do I build the string within the trigger a
ct new.col1,new.co2…new.colN)
>
> This doesn't:
>
> sql := 'Insert into A (col1,col2,…colN) ';
> sql := sql || 'Select new.col1,new.co2…new.colN)';
> Execute sql;
>
> ERROR: missing FROM-clause entry for table "new"
>
> There is not
;
> sql := 'Insert into A (col1,col2,colN) ';
> sql := sql || 'Select new.col1,new.co2new.colN)';
> Execute sql;
>
> ERROR: missing FROM-clause entry for table "new"
>
>
>
> There is nothing wrong with the resulting code from sql beca