I kept getting this darned error from an AFTER trigger and I don't know why. The portion of the code that was
exerciseddid a couple selects, but no update, insert or delete on any other table, so that would seem to eliminate
anothertrigger sending this error.
How did I fix it, you ask? I noticed that tcl comments (lines starting with #) had some effect. I deleted all my
comments,and all is well. However, there are some "elog DEBUG" lines in there that seem to be critical, if I remove
them,the same error comes up.
I can and will work up a simple test case so you all can reproduce it, but before I go to the effort, is this a known
issue? I have found nothing about it in the docs or google search.
From what I read in the docs, the return value, if any, from a pltcl trigger function is ignored if it is an AFTER
trigger,right?
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org