Re: Target lists can have at most 1664 entries?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Target lists can have at most 1664 entries?
Date: 2008-07-02 07:04:04
Message-ID: 4545.1214982244@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2008-07-02 07:06:56 Re: Target lists can have at most 1664 entries?
Previous Message Magnus Hagander 2008-07-02 07:03:04 Re: Target lists can have at most 1664 entries?