Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger not firing - Mailing list pgsql-general

From Hans
Subject Re: Trigger not firing
Date
Msg-id 1001ae8e-7423-2d02-4658-1f0b79e5a794@xs4all.nl
Whole thread Raw
In response to Re: Trigger not firing  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Trigger not firing
Next
From: "Andrus"
Date:
Subject: Re: How to start slave after pg_basebackup. Why min_wal_size and wal_keep_segments are duplicated