Re: issues with dropped columns in plpgsql code again

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: issues with dropped columns in plpgsql code again
Дата
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
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> 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
Дата:
Сообщение: Re: [patch] PSQLDIR not passed to pg_regress in contrib/pg_upgrade/test.sh
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: corrupt pages detected by enabling checksums