Creating a temporary table isn't working

Поиск
Список
Период
Сортировка
От Darvin Zuch
Тема Creating a temporary table isn't working
Дата
Msg-id 001901bf2b14$bd26cc40$0ddba8c0@zuchdarvinjava.aprofile.com
обсуждение исходный текст
Ответы Re: [GENERAL] Creating a temporary table isn't working  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [GENERAL] Creating a temporary table isn't working  (Paul Branston <apbran@rannoch.demon.co.uk>)
Список pgsql-general
Good Morning All!

Really simple question.
I put in the following command and I get a parse error but when I get rid of
the optional TEMP it works okay.  The docs seem to say this is how its done.

gammamatrix=> CREATE TEMP TABLE Start (VatiID int NOT NULL, TrimID int,
BodyID int, GVWRID int, DrivetrainID int, EngineID int, TransID int , FuelId
int);
ERROR:  parser: parse error at or near "temp"

Any help would be greatly appreciated.

Darvin Zuch


В списке pgsql-general по дате отправления:

Предыдущее
От: "amy cheng"
Дата:
Сообщение: Re: [GENERAL] Alter table possibility
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Creating a temporary table isn't working