Re: problem trying to create a temp table

On Friday, February 24, 2012 5:46:06 am mgould(at)isstrucksoftware(dot)net wrote:
> Andrew,
>
> That is acutally what the second run was supposed to be. I copied the
> original on instead of the second instance, but the results were the
> same.

Are you doing all this in the same session?:

test(5432)postgres=#create temp table temp_test(id int, fld_1 text);
CREATE TABLE

test(5432)postgres=#SELECT * from temp_test;
id | fld_1
----+-------
(0 rows)

If so what are the exact commands you are executing?

>
>
> Michael Gould
> Intermodal Software Solutions, LLC
> 904-226-0978
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com