Re: Got error on CREATE TABLE AS (+Bug?) - Mailing list pgsql-general

"Command Prompt, Inc." <pgsql-general@commandprompt.com> writes:
> lx=# CREATE TABLE abc (a char, b char, c char);
> CREATE
> lx=# CREATE TABLE xyz (x, y, z) AS SELECT * FROM abc;
> ERROR:  CREATE TABLE/AS SELECT has mismatched column count
> lx=# CREATE TABLE xyz (x, y, z) AS SELECT a, b, c FROM abc;
> SELECT

Looks like a bug to me too.  Will look into it.

            regards, tom lane