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@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