> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
