Re: issues with dropped columns in plpgsql code again

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: issues with dropped columns in plpgsql code again
Дата
в 20:17:52
Msg-id
15412.1368217066@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
issues with dropped columns in plpgsql code again Pavel Stehule <pavel.stehule@gmail.com>
Re: issues with dropped columns in plpgsql code again Tom Lane <tgl@sss.pgh.pa.us>
Re: issues with dropped columns in plpgsql code again Pavel Stehule <pavel.stehule@gmail.com>
Re: issues with dropped columns in plpgsql code again Pavel Stehule <pavel.stehule@gmail.com>
Re: issues with dropped columns in plpgsql code again Szymon Guz <mabewlun@gmail.com>
Pavel Stehule  writes:
> One user reported a issues with triggers related to dropped columns.
> When I checked his code, I found a more possible problems.

This is just the same kind of modified-rowtype problem we've discussed
before.

I continue to maintain that the only realistic fix is to stop using the
PLPGSQL_DTYPE_ROW infrastructure for variables of externally-defined
composite types.  In the last go-round, this was rejected on the
(unproven) assumption that it would make things slower.  But as a wise
man once said, you can make code arbitrarily fast if it doesn't have to
give the right answer.
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
От: Jeff Davis
Дата:
FAQ