BUG #4650: can't specify table schema in CREATE TABLE AS

Поиск
Список
Период
Сортировка
От Thue Janus Kristensen
Тема BUG #4650: can't specify table schema in CREATE TABLE AS
Дата
Msg-id 200902121252.n1CCqFOa091243@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4650: can't specify table schema in CREATE TABLE AS
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4650
Logged by:          Thue Janus Kristensen
Email address:      thuejk@gmail.com
PostgreSQL version: 8.3.5
Operating system:   Linux
Description:        can't specify table schema in CREATE TABLE AS
Details:

According to
http://www.postgresql.org/docs/8.3/interactive/sql-createtableas.html , the
following should work:

CREATE TABLE test(a INT) AS (SELECT 1);

However:

k3_dev_tjk=> CREATE TABLE test(a INT) AS (SELECT 1);
ERROR:  syntax error at or near "AS"
LINE 1: CREATE TABLE test(a INT) AS (SELECT 1);

It works if I drop the table schema:

k3_dev_tjk=> CREATE TABLE test AS (SELECT 1);
SELECT

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #4648: needless deadlock on tables having foreign-key
Следующее
От: Konstantin
Дата:
Сообщение: Re: BUG #4648: needless deadlock on tables having foreign-key