Re: Function problem after alter table

Sean Dooley <srd1(at)st-andrews(dot)ac(dot)uk> writes:
> FOR RESULTSET IN
> SELECT * FROM item_date WHERE item_id = in_item_id
> LOOP
> RETURN NEXT resultset;
> END LOOP;

> This works fine, returns all the matching data from item_date
> However, if I alter the table item_date, for example
> ALTER TABLE item_date ADD COLUMN foo text;
> When I run the function now, I get the error
> ERROR: wrong record type supplied in RETURN NEXT

This example works for me in PG 8.3. In prior releases I think you'd
need to use FOR ... IN EXECUTE to force the SELECT to get re-planned
each time through.

regards, tom lane