Обсуждение: Creating a temporary table isn't working

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

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 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.

Temp tables are only in 6.5.*.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Tue, 9 Nov 1999, Darvin Zuch wrote:

> 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"

Replace the word temp with some other name, e.g. T1. Is temp not a
reserved word ?

Paul