Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Target list...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15981 of 17437
Post > Topic >>

Re: Target lists can have at most 1664 entries?

by btj@[EMAIL PROTECTED] (=?UTF-8?Q?Bj=C3=B8rn?= T Johansen) Jul 6, 2008 at 12:04 AM

On Sat, 5 Jul 2008 08:17:37 -0700
David Fetter <david@[EMAIL PROTECTED]
> wrote:

> On Wed, Jul 02, 2008 at 09:22:50AM +0200, Bj=C3=B8rn T Johansen wrote:
> > On Wed, 02 Jul 2008 03:04:04 -0400
> > Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
> > > =3D?UTF-8?Q?Bj=3DC3=3DB8rn?=3D T Johansen <btj@[EMAIL PROTECTED]
> writes:
> > > > What does this mean and how can it be fixed?
> > >=20
> > > Reduce the number of columns in your SELECTs?
> > >=20
> > > 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).
> >=20
> > Well, I do agree but it is not my design and a "fix" in PostgreSQL
> > would be quicker than fixing the design....
>=20
> That's where you're badly mistaken.  Your application is completely
> broken, and trying to adjust everybody else's Postgres to accommodate
> *your* broken application is both selfish and short-sighted.  It's
> selfish because you're asking others to do work they don't need to do
> just so you can avoid doing work you need to do, and it's
> short-sighted because your application is guaranteed to be broken in
> lots of other ways if it's broken this way.
>=20
> Fix the application, and if you can't, find another job where they're
> not being idiots.  There are plenty of Postgres-related jobs out
> there.
>=20
> Cheers,
> David.

Actually, this discussion was finished a long time ago (we are already
look=
ing at the Hibernate config and domain modell)..
And btw, I wasn't proposing a change in PostgreSQL, only if there were
some=
 config that could be changed to accomodate this...


BTJ

--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 1 Posts in Topic:
Re: Target lists can have at most 1664 entries?
btj@[EMAIL PROTECTED] (=  2008-07-06 00:04:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:13:23 CST 2008.