you understand why this is happening, right? The trigger detects an insert into the table -> the trigger inserts another row into the table -> the trigger detects the new row -> the trigger inserts another row etc.
This is presumably not what you wanted, so what do you really want to happen?
Reply With Quote