> Does any know of a way that I can alter a temporary table by adding a
> serial column within a stored procedure after it has been created?
It should just work. What did you try, exactly, and what error message
did you get?
I have the following code in my stored procedure:
create temporary table t_resultset as select * from
get_createtempmsg();
alter table t_resultset add column seq serial;
Where get_createtempmsg() is a stored procedure that returns a composite
type with no records.
The error I get is - relation "public.t_resultset" does not exist.
I am using 8.1.3