Received: (from nobody@localhost) by hub.org (8.9.3/8.9.3) id KAA42320; Mon, 21 Jun 1999 10:32:31 -0400 (EDT) (envelope-from nobody) Date: Mon, 21 Jun 1999 10:32:31 -0400 (EDT) From: Unprivileged user Message-Id: <199906211432.KAA42320@hub.org> To: pgsql-bugs@postgresql.org Reply-to: Marinos Yannikos Subject: General Bug Report: CREATE TABLE AS doesn't work ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Marinos Yannikos Your email address : mjy@pobox.com Category : runtime: back-end: SQL Severity : serious Summary: CREATE TABLE AS doesn't work System Configuration -------------------- Operating System : Linux 2.2.9 PostgreSQL version : 6.5.0 Compiler used : egcs-1.1.1 release Hardware: --------- Linux XXX 2.2.9 #11 Sat Jun 12 04:23:30 MEST 1999 i686 unknown Celeron 300A 192MB, EIDE system Versions of other tools: ------------------------ -------------------------------------------------------------------------- Problem Description: -------------------- The CREATE TABLE AS syntax doesn't work the way it is described in the manual: ******************************************************************************* QUERY: create table xxx (foo int4) as select 1; ******************************************************************************* press return to continue .. ERROR: parser: parse error at or near "as" -------------------------------------------------------------------------- Test Case: ---------- see above -------------------------------------------------------------------------- Solution: --------- Implement it :-) --------------------------------------------------------------------------