Re: Trigger issue, bug? on 7.2.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: miguel(at)ipatimup(dot)pt
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger issue, bug? on 7.2.1
Date: 2003-03-18 14:34:20
Message-ID: 19094.1047998060@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

"Miguel Carvalho" <miguel(at)ipatimup(dot)pt> writes:
> The trigger code will force another trigger fire because of the changes
> in the record. I'm i right?

No, altering the NEW record doesn't cause any additional trigger
firings. If it did, such a trigger would be infinitely recursive.

Your DELETE issued by the trigger would cause firing of ON DELETE
triggers, but not another firing of ON UPDATE.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-18 14:37:33 Re: insert aliases?
Previous Message Bruce Momjian 2003-03-18 14:30:51 Red Hat snubbed by Oracle

Browse pgsql-sql by date

  From Date Subject
Next Message alexj 2003-03-18 14:47:55 trouble with query
Previous Message Miguel Carvalho 2003-03-18 14:15:31 Trigger issue, bug? on 7.2.1