"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