Re: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.
Дата
Msg-id 26753.1322160537@sss.pgh.pa.us
обсуждение исходный текст
Ответ на "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.  (Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Philippe Lang
Дата:
Сообщение: Convert string to UNICODE & migration FROM 7.4 to 9.1
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: General performance/load issue