pending triggers infinite list

From: Миша Тюрин <tmihail(at)bk(dot)ru>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pending triggers infinite list
Date: 2013-02-08 17:41:07
Message-ID: 1360345267.238074373@f258.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hi all

I've got suspicious behavior for transaction cooked with deferrable trigger. if trigger has update on row of his target table we get infinite "recursion" without limitation of stack depth.

trigger -> update -> trigger -> update -> ... ... -- infinite pending list :)

- Misha

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2013-02-08 17:41:15 Re: Alias hstore's ? to ~ so that it works with JDBC
Previous Message Josh Berkus 2013-02-08 17:40:26 Re: Considering Gerrit for CFs