Bob Pawley wrote:
Hi FolksI have three triggers and associated functions that fire on one insert and moves row ID information to five different tables.. I am getting an error message "stack depth limit exceeded". [snip]
You've almost certainly got a recursive trigger in there. The default stack depth should be good for hundreds of function calls, but if your triggers are recursive then no depth will be enough. Regards, Paul Tillotson