Re: BUG #5816: index not used in function - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5816: index not used in function
Date
Msg-id AANLkTikkRo4H94nPdrvqCPQh52rUcGi47NPM=c7pxJ85@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5816: index not used in function  ("frank" <frank@ros-i.com>)
Responses Re: BUG #5816: index not used in function  ("frank" <frank@ros-i.com>)
List pgsql-bugs
On Mon, Jan 10, 2011 at 9:07 PM, frank <frank@ros-i.com> wrote:
> More can be said, but why one wants to defend a defect is quite beyond me.

I guess the question is whether you want to solve your problem or
improve PostgreSQL.  If you want to solve your immediate problem, the
advice given thus far is probably enough for you to do it.  If the
goal is to improve PostgreSQL, that's a worthy goal and I don't think
anyone here would say otherwise.  The current behavior is not ideal,
but improving it is not easy.

When people say "it's not a bug", they don't mean "this is the best
possible behavior anyone can imagine"; they mean "we know that it
works this way and we haven't actually figured out a way to do any
better yet without causing other problems".

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #5809: bigserial duplicate value
Next
From: Korry Douglas
Date:
Subject: Re: BUG #5816: index not used in function