From: Unprivileged user <nobody>
To: pgsql-bugs@postgresql.org
Subject: General Bug Report: CREATE TABLE AS doesn't work
Date: Mon, 21 Jun 1999 10:32:31 -0400 (EDT)
Message-ID: <199906211432.KAA42320@hub.org> (raw)
============================================================================
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 :-)
--------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: nobody, pgsql-bugs@postgresql.org
Subject: Re: General Bug Report: CREATE TABLE AS doesn't work
In-Reply-To: <199906211432.KAA42320@hub.org>
References: <199906211432.KAA42320@hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox