Re: Target lists can have at most 1664 entries?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Target lists can have at most 1664 entries?
Date: 2008-07-02 07:22:50
Message-ID: 20080702092250.601cb680@btj-laptop.asp-as.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 02 Jul 2008 03:04:04 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <btj(at)havleik(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-07-02 07:24:38 Re: Target lists can have at most 1664 entries?
Previous Message Richard Huxton 2008-07-02 07:15:22 Re: Target lists can have at most 1664 entries?