Re: [GENERAL] Alter Temporary table in Stored Procedure

2008-02-10 Thread Tom Lane
"Nykolyn, Andrew" <[EMAIL PROTECTED]> writes: > 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; > The error I get is - relation "public.t_resultset" does no

Re: [GENERAL] Alter Temporary table in Stored Procedure

2008-02-10 Thread Nykolyn, Andrew
> 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 tem

Re: [GENERAL] Alter Temporary table in Stored Procedure

2008-02-10 Thread Tom Lane
"Nykolyn, Andrew" <[EMAIL PROTECTED]> writes: > 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? r