Adding column breaks function with composite type argument
От
Jeff Eckermann
Тема
Adding column breaks function with composite type argument
Дата
Msg-id
08CD1781F85AD4118E0800A0C9B8580B094A6D@NEZU
Список
Дерево обсуждения
Adding column breaks function with composite type argument Jeff Eckermann <jeckermann@verio.net>
Re: Adding column breaks function with composite type argument Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления