Re: Trigger issue, bug? on 7.2.1
От
Miguel Carvalho
Тема
Re: Trigger issue, bug? on 7.2.1
Дата
Msg-id
14930.213.13.176.13.1048164905.squirrel@www.ipatimup.pt
Ответ на
Re: Trigger issue, bug? on 7.2.1 (Tom Lane)
Список
Дерево обсуждения
Trigger issue, bug? on 7.2.1 "Miguel Carvalho" <miguel@ipatimup.pt>
Re: Trigger issue, bug? on 7.2.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: Trigger issue, bug? on 7.2.1 "Miguel Carvalho" <miguel@ipatimup.pt>
> "Miguel Carvalho" 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. > I see your point, you are completely right! > Your DELETE issued by the trigger would cause firing of ON DELETE > triggers, but not another firing of ON UPDATE. You are right, too. When i was repplying to your message, after stripping some lines of the trigger code, i have found that the second trigger fire ( not actualy a real trigger fire ) was caused by a bad logic in the trigger code. Thank's to all for the repplies. Regards Miguel Carvalho
В списке pgsql-general по дате отправления
От: Daniel R. Anderson
Дата: