pltcl: Invalid return list from trigger - must have even # of elements

I kept getting this darned error from an AFTER trigger and I don't know why. The portion of the code that was exercised did a couple selects, but no update, insert or delete on any other table, so that would seem to eliminate another trigger 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(at)tpchd(dot)org