pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
General Bug Report: CREATE TABLE AS doesn't work
2+ messages / 2 participants
[nested] [flat]

* General Bug Report: CREATE TABLE AS doesn't work
@ 1999-06-21 14:32  Unprivileged user <nobody>
  0 siblings, 1 reply; 2+ messages in thread

From: Unprivileged user @ 1999-06-21 14:32 UTC (permalink / raw)
  To: pgsql-bugs@postgresql.org


============================================================================
                        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 :-)


--------------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [BUGS] General Bug Report: CREATE TABLE AS doesn't work
@ 1999-06-21 20:10  Fomichev Michael <fomichev@null.ru>
  parent: Unprivileged user <nobody>
  0 siblings, 0 replies; 2+ messages in thread

From: Fomichev Michael @ 1999-06-21 20:10 UTC (permalink / raw)
  To: pgsql-sql; +Cc: pgsql-bugs@postgreSQL.org; mjy@pobox.com


The query should look like this:
create table xxx (foo) as select 1;
This syntax described in manual for PostgreSQL v6.4.2

For example:
********************
template1=> create table xxx (foo) as select 1;
SELECT
template1=> select * from xxx;
foo
---
  1
(1 row)
*******************

@------------------+-----------------------------------------------@
| Fomichev Michail | The Government of Kamchatka region.           |
|<fomichev@null.ru>| The Labour and Social Development Department. |
`------------------+-----------------------------------------------'

On Mon, 21 Jun 1999, Unprivileged user wrote:

> 
> ============================================================================
>                         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 :-)
> 
> 
> --------------------------------------------------------------------------
> 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-06-21 20:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-21 14:32 General Bug Report: CREATE TABLE AS doesn't work Unprivileged user <nobody>
1999-06-21 20:10 ` Fomichev Michael <fomichev@null.ru>

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