I should clarify- I am using PG 7.2 and composing my queries with pgAdminII
on win32.
If I try to select * from that temp table, I get an error claiming relation
does not exist. I had used temp tables previously, but I think that may have
been on 7.1.
Is it possible temp tables have subtly changed, breaking my GUI?
If I make a query like this, it complains 'current_inventory' does not
exist.
"create temporary table current_inventory AS select *
from inventory where qty > 0;
select * from current_inventory"
>In < 7.3, that is the internal table name. References to the table will
>still work.
>
>In 7.3 all temp tables are in their own schema, so they have usual
>names.
>
>---------------------------------------------------------------------------
>
>jwsacksteder@ramprecision.com wrote:
>> If I try to make a temporary table like this-
>>
>> create temporary table current_inventory AS
>> select * from inventory where qty > 0
>>
>> - I get a table called 'pg_temp_4473_0' instead of my specified name.
