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 15980 of 16965
Post > Topic >>

Re: Target lists can have at most 1664 entries?

by david@[EMAIL PROTECTED] (David Fetter) Jul 5, 2008 at 08:17 AM

On Wed, Jul 02, 2008 at 09:22:50AM +0200, Bjørn T Johansen wrote:
> On Wed, 02 Jul 2008 03:04:04 -0400
> Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
> > =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <btj@[EMAIL PROTECTED]
> 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).
> 
> Well, I do agree but it is not my design and a "fix" in PostgreSQL
> would be quicker than fixing the design....

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.

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.

Cheers,
David.
-- 
David Fetter <david@[EMAIL PROTECTED]
> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@[EMAIL PROTECTED]
 to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

-- 
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?
david@[EMAIL PROTECTED]   2008-07-05 08:17:37 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Mon Oct 13 7:02:37 CDT 2008.