Re: [GENERAL] Creating a temporary table isn't working

From: Paul Branston <apbran(at)rannoch(dot)demon(dot)co(dot)uk>
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 06:15:16
Message-ID: Pine.LNX.4.10.9911100614280.17164-100000@rannoch.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edouard DESSIOUX 1999-11-10 13:24:19 Types available
Previous Message william drury 1999-11-10 03:22:06 [ADMIN]: help!