INSERT Failed. 5784: Illegal usage of Identity Column-In trigger

Database

INSERT Failed. 5784: Illegal usage of Identity Column-In trigger

INSERT Failed. 5784: Illegal usage of Identity Column -inside a trigger

Hi,

I am using a trigger to insert a row into a backup table when a row is created in the actual table. Both tables have identity column and i am not using the idcolumn in the trigger.

REPLACE

TRIGGER trigger name

AFTER

INSERT ON table

REFERENCING

NEW AS new_rec

FOR

EACH ROW

(

INS

backup_table

(

col1,col2,col3)

VALUES

(col1,col2,col3);

)

;

I tried changing the backup table to generated by always and tried but still doesnt work. The id column is the primary index column.

We get this error -INSERT Failed. 5784: Illegal usage of Identity Column .

any suggestion??

Thanks,

Priti