Re: temporary table oddity
От | jwsacksteder@ramprecision.com |
---|---|
Тема | Re: temporary table oddity |
Дата | |
Msg-id | 71650A6F73F1D411BE8000805F65E3CB3B31BE@SRV-03 обсуждение исходный текст |
Ответ на | temporary table oddity (jwsacksteder@ramprecision.com) |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: