From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: CREATE TABLE AS doesn't work |
Date: | 1999-06-21 14:32:31 |
Message-ID: | 199906211432.KAA42320@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-sql |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Marinos Yannikos
Your email address : mjy(at)pobox(dot)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 :-)
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Fomichev Michael | 1999-06-21 20:10:38 | Re: [BUGS] General Bug Report: CREATE TABLE AS doesn't work |
Previous Message | Oleg Bartunov | 1999-06-21 08:48:14 | RE: [BUGS] General Bug Report: Error parsing negative numbers |
From | Date | Subject | |
---|---|---|---|
Next Message | Donald Jackson | 1999-06-21 16:31:19 | problems working with refint functions |
Previous Message | José Soares | 1999-06-21 12:13:08 | Re: [SQL] Letting a function work on NULL |