Re: Function problem after alter table

Sean Dooley <srd1@[EMAIL PROTECTED]
> 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

--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-novice