From: | "Ian Harding" <ianh(at)tpchd(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pltcl: Invalid return list from trigger - must have even # of elements |
Date: | 2002-02-26 22:55:01 |
Message-ID: | sc7ba238.037@mail.tpchd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill McGonigle | 2002-02-26 23:00:02 | Re: pg_dumpall storing multiple copies of DB's? |
Previous Message | Doug McNaught | 2002-02-26 22:49:23 | Re: pg_dumpall storing multiple copies of DB's? |