you trigger can be much faster if you replace FOREACH cycle by unnestINSERT INTO generic.usergroup_test(test_id, usergroup_id) VALUES(NEW.id, UNNEST(NEW.usergroup_ids));
Thanks! Appreciated :-) Hans
you trigger can be much faster if you replace FOREACH cycle by unnestINSERT INTO generic.usergroup_test(test_id, usergroup_id) VALUES(NEW.id, UNNEST(NEW.usergroup_ids));
Thanks! Appreciated :-) Hans