Ow Mun Heng wrote: > Hi, > > I'm playing around with triggers to implement partitioning. > I hit something which I don't know what and I don't have internet here > at work to find out what is the cause. > > > ERROR : stack depth limit exceeded > > I see that this is one of the options in postgresql.conf but I don't > know exactly what it is.
Sounds like you may have created a situation with infinite recursion. Like in some branch your trigger is inserting back into the parent table, thus firing the trigger again in an endless loop, instead of inserting it into the proper child table. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
