It seems like that function has some syntax errors, and also doesn't do
what you want since I presume the "from employee" bit would mean you get
many rows inserted into that temp table for all the existing data and not
the one row you are operating on at the moment the trigger fires.

It is worth noting also that if bulk operations are at all common for this
table then writing this as an after statement trigger will likely be
helpful for performance.

For full context, we'd need to see how the function insert_info is defined.

Reply via email to