Skip site navigation (1) Skip section navigation (2)

Re: Trigger question

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger question
Date: 2004-08-26 19:45:29
Message-ID: cglekj$2r28$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
Ok, it is working fine.

> Hi list,
> 
> i'm a bit confused. I have a table with a trigger after insert. It is 
> possible that this trigger will do inserts in the same table, but is the 
> after insert trigger fired again in this case? (I would need this)
> 
> e.g.
> 
> USER INSERT
> 
> BEFORE TRIGGER
> AFTER TRIGGER
> 
> ->DECIDES TO INSERT X ROWS IN THE SAME TABLE
> 
> ->BEFORE TRIGGER (this one is fired for each row the after trigger inserts)
> 
> ->AFTER TRIGGER AGAIN???? FOR EACH ROW THE AFTER TRIGGER INSERTED

In response to

pgsql-general by date

Next:From: Jan WieckDate: 2004-08-26 20:12:48
Subject: Re: Problem to connect to the Windows Port
Previous:From: Cornelia BoenigkDate: 2004-08-26 18:20:31
Subject: Re: Problem to connect to the Windows Port

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group