Postgres Pro
Downloads
Home   >   mailing lists

Re: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error. - Mailing list pgsql-general

From Tom Lane
Subject Re: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.
Date
Msg-id 26753.1322160537@sss.pgh.pa.us
Whole thread Raw
In response to "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.  (Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>)
List pgsql-general
Tree view 
Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp> writes:
> Accroding to http://www.postgresql.org/docs/9.1/interactive/sql-createtableas.html ,
> "CREATE TABLE table_name AS EXECUTE name WITH DATA" seems a right syntax,
> but,this statement becomes a SYNTAX ERROR.

Hmm ... it looks like WITH [NO] DATA is actually only implemented for
the query = SelectStmt case, not the query = ExecuteStmt case.  We need
a less klugy implementation to support EXECUTE :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Philippe Lang
Date:
Subject: Convert string to UNICODE & migration FROM 7.4 to 9.1
Next
From: Cédric Villemain
Date:
Subject: Re: General performance/load issue