Re: Got error on CREATE TABLE AS (+Bug?)

"Command Prompt, Inc." <pgsql-general(at)commandprompt(dot)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