Yes, it will be fixed in 7.2, which is the next release.
---------------------------------------------------------------------------
> Thanks,
> will this be fixed on the next release?
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Sunday, November 04, 2001 9:02 PM
> To: Command Prompt, Inc.; Jeff Lu; Postgresql General
> Subject: Re: [GENERAL] Got error on CREATE TABLE AS (+Bug?)
>
>
> Tom Lane <tgl@sss.pgh.pa.us> writes:
> > "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.
>
> Fix committed for 7.2.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
