Re: [BUGS] BUG #1681: Selection problem

2005-05-31 Thread FREMAUX Benjamin SOFRECOM
Thank you Michael Fuhr a écrit : [Please copy the mailing list on replies so others can participate in and learn from the discussion.] On Fri, May 27, 2005 at 10:08:20AM +0200, FREMAUX Benjamin SOFRECOM wrote: I have effectively an index (PK) on list.group_artifact_id. I solved the problem

Re: [BUGS] BUG #1681: Selection problem

2005-05-27 Thread Michael Fuhr
[Please copy the mailing list on replies so others can participate in and learn from the discussion.] On Fri, May 27, 2005 at 10:08:20AM +0200, FREMAUX Benjamin SOFRECOM wrote: > > I have effectively an index (PK) on list.group_artifact_id. I solved the > problem with an index rebuild. A reinde

Re: [BUGS] BUG #1681: Selection problem

2005-05-26 Thread Michael Fuhr
On Thu, May 26, 2005 at 02:50:44PM +0100, fremaux wrote: > > PostgreSQL version: 7.2.2 PostgreSQL 7.2.2 is almost three years old -- consider upgrading to 7.2.8, or better yet, 8.0.3. > SELECT list.group_artifact_id, list.name > FROM artifact_group_list list > WHERE (list.group_artifact_id=167)

[BUGS] BUG #1681: Selection problem

2005-05-26 Thread fremaux
The following bug has been logged online: Bug reference: 1681 Logged by: fremaux Email address: [EMAIL PROTECTED] PostgreSQL version: 7.2.2 Operating system: Linux kernel 2.4.6.19-mdk Description:Selection problem Details: following query : SELECT list.group_artifac