Re: after update trigger ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tmoore <tmoore(at)ttitech(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: after update trigger ?
Date: 2011-04-22 14:39:20
Message-ID: 17675.1303483160@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

tmoore <tmoore(at)ttitech(dot)net> writes:
> Can an after update trigger function do an insert into the the same table ?

Sure. You have to avoid recursively triggering the same trigger, but an
insert wouldn't trigger the update trigger.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message e-letter 2011-04-23 07:40:08 Re: [pgsql-novice] Daily digest v1.2917 (11 messages)
Previous Message raghu ram 2011-04-22 14:37:26 Re: after update trigger ?