Creating a temporary table isn't working

From: "Darvin Zuch" <darvin(dot)zuch(at)autoprofile(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Creating a temporary table isn't working
Date: 1999-11-10 00:44:23
Message-ID: 001901bf2b14$bd26cc40$0ddba8c0@zuchdarvinjava.aprofile.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-11-10 00:46:17 Re: [GENERAL] Creating a temporary table isn't working
Previous Message Alain TESIO 1999-11-09 16:24:31 Re: [GENERAL] Alter table possibility