Re: pltcl - "Cache lookup for attribute" error - version 2 - Mailing list pgsql-patches

From Tom Lane
Subject Re: pltcl - "Cache lookup for attribute" error - version 2
Date
Msg-id 29558.1074886731@sss.pgh.pa.us
Whole thread Raw
In response to Re: pltcl - "Cache lookup for attribute" error - version  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: pltcl - "Cache lookup for attribute" error - version
List pgsql-patches
Jan Wieck <JanWieck@Yahoo.com> writes:
> When assigning a tuple to an array, PL/Tcl creates one extra array
> element .tupno telling the SPI_tuptable index of the result tuple. I
> think I originally planned to have more of these critters ... but
> probably never really needed them. It is in there since 6.3!

> Bottom line is, if one has a trigger, and inside the trigger he does an
> SPI_exec, fetches a tuple into an array and then returns [array get x]
> instead of new or old ... so from the back through the right chest into
> the left eye ... then it will fail if the .tupno isn't filtered out.

Hm.  Perhaps we should tighten the test to reject only ".tupno", rather
than any name starting with dot?

            regards, tom lane

pgsql-patches by date:

Previous
From: venkycraj@yahoo.com (venky)
Date:
Subject: Calling a java program thru a trigger or a function in postgresql
Next
From: Neil Conway
Date:
Subject: cleanup psql memory handling