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

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

Responses

Browse pgsql-general by date

  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?