Re: Trigger not firing

From: Hans <hguijtra(at)xs4all(dot)nl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Trigger not firing
Date: 2020-06-01 10:15:41
Message-ID: 1001ae8e-7423-2d02-4658-1f0b79e5a794@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> you trigger can be much faster if you replace FOREACH cycle by unnest
>
> INSERT INTO generic.usergroup_test(test_id, usergroup_id) VALUES(NEW.id,
> UNNEST(NEW.usergroup_ids));

Thanks! Appreciated :-)

Hans

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2020-06-01 10:26:12 Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated
Previous Message Pavel Stehule 2020-06-01 10:14:07 Re: Trigger not firing