From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Darvin Zuch <darvin(dot)zuch(at)autoprofile(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Creating a temporary table isn't working |
Date: | 1999-11-10 00:46:17 |
Message-ID: | 199911100046.TAA23421@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
[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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Kirkpatrick | 1999-11-10 00:49:33 | Re: [GENERAL] Postgres on Linux Alpha |
Previous Message | Darvin Zuch | 1999-11-10 00:44:23 | Creating a temporary table isn't working |