Re: Target lists can have at most 1664 entries? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: Target lists can have at most 1664 entries?
Date
Msg-id 20080702092250.601cb680@btj-laptop.asp-as.no
Whole thread Raw
In response to Re: Target lists can have at most 1664 entries?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Target lists can have at most 1664 entries?
List pgsql-general
On Wed, 02 Jul 2008 03:04:04 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <btj@havleik.no> writes:
> > What does this mean and how can it be fixed?
>
> Reduce the number of columns in your SELECTs?
>
> This whiffs to me of excruciatingly bad schema design.  How could you
> possibly need upwards of a thousand columns in a query result?
> IMHO reasonable column counts are O(10), not O(bignum).
>
>             regards, tom lane
>

Well, I do agree but it is not my design and a "fix" in PostgreSQL would be quicker than fixing the design....

BTJ

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Target lists can have at most 1664 entries?
Next
From: Volkan YAZICI
Date:
Subject: Memory Problem