Received: from poptop.llnl.gov (poptop.llnl.gov [128.115.18.65]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA01216 for ; Tue, 13 Jul 1999 00:34:45 -0400 (EDT) (envelope-from sbradley@llnl.gov) Received: from C31048-A.lvrmr1.sfba.home.com (c31048-a.lvrmr1.sfba.home.com [24.5.24.101]) by poptop.llnl.gov (8.8.8/LLNL-3.0.2/pop.llnl.gov-5.1) with SMTP id VAA25344 for ; Mon, 12 Jul 1999 21:34:36 -0700 (PDT) Message-Id: <3.0.3.32.19990712213105.007af3e0@poptop.llnl.gov> X-Sender: e097106@poptop.llnl.gov (Unverified) X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.3 (32) Date: Mon, 12 Jul 1999 21:31:05 -0500 To: pgsql-sql@postgresql.org From: Steven Bradley Subject: create temp table Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" When I try to create a temporary table using the following command: create temp table foo as select * from employees; I get the following error: ERROR: parser: parse error at or near "temp" I get a similar error if I try: create temporary table foo as select * from employees; Can anyone tell me what I'm doing wrong? This seems so simple! Thanks in advance... PS: I'm using PostgreSQL 6.4.2. Steven Bradley Lawrence Livermore National Laboratory Livermore, California 94550 sbradley@llnl.gov