Adding column breaks function with composite type argument

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Adding column breaks function with composite type argument
Дата
Msg-id 08CD1781F85AD4118E0800A0C9B8580B094A6D@NEZU
обсуждение исходный текст
Ответы Re: Adding column breaks function with composite type argument  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I created a pl/pgsql function which takes a table row as an argument,
returning a value based on a comparison of two fields in each row.
This worked fine until I did an "ALTER TABLE ... ADD COLUMN ... ;",
whereupon the function failed to work, producing an error message : "ERROR:
query didn't return correct # of attributes for $1"
Dropping and recreating the function made no difference.
Rewriting the function to just take those two fields as arguments is no
biggie, but: why should this fail?

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: rserv
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Minor documentation bug