Re: pltcl - "Cache lookup for attribute" error - version 2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pltcl - "Cache lookup for attribute" error - version 2
Дата
Msg-id 29558.1074886731@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pltcl - "Cache lookup for attribute" error - version  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: pltcl - "Cache lookup for attribute" error - version  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: venkycraj@yahoo.com (venky)
Дата:
Сообщение: Calling a java program thru a trigger or a function in postgresql
Следующее
От: Neil Conway
Дата:
Сообщение: cleanup psql memory handling