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

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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)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(at)sss(dot)pgh(dot)pa(dot)us> writes:
> > "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.
>
> Fix committed for 7.2.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026