pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Keith Worthington <keithw@narrowpathinc.com>
To: PostgreSQL Perform <pgsql-performance@postgresql.org>
Subject: Triggers with FOR EACH STATEMENT
Date: Fri, 1 Apr 2005 11:20:25 -0500
Message-ID: <20050401161901.M13616@narrowpathinc.com> (raw)

Hi All,

I have a trigger function that copies data from an input table to a table in
the actual data model.  The data model table has a trigger after update on it.
 Is the first trigger fired after the copy terminates or after each insert?
Is the second trigger fired after the first trigger is complete or once for
every iteration of the loop in the first trigger?  I only want these triggers
to fire after the previous action is complete.  That is what I thought I was
getting when I chose the FOR EACH STATEMENT attribute.  Here are excerpts from
the various programs that are running.  Your thoughts are appreciated.



Message-ID: <20050401161901.M13616@narrowpathinc.com>
Permalink:  ../20050401161901.M13616@narrowpathinc.com/
Also on:    postgresql.org/message-id/20050401161901.M13616@narrowpathinc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: keithw@narrowpathinc.com
  Subject: Re: Triggers with FOR EACH STATEMENT
  In-Reply-To: <20050401161901.M13616@narrowpathinc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox